excel for data manipulation

A selection of data manipulation tasks that I often encounter prior to modeling, that is, prepare the dataset for exporting to a standard statistics package.

Multiple indicators rolled/concatenated into a single column; for example:

---

Column A needs splitting into 2 separate columns:
one for the treatment label, one for the day indicator, like so:

---

Which is accomplished by using text extractor functions:

---