Excel: Split Text into Different Cells
Back in the ’90’s, a client gave me a large Excel file that needed to be exported into an Access database. Thing was, each address had been typed into one cell, instead of separate cells, i.e., one cell each for street address, city, state, and zip code.
I cringed at the thought of having to manually split the data into separate cells, and was frantic about how to proceed. I had a programmer friend, and he came to my rescue, creating some kind of formula or macro. Within practically a blink of the eye, the data got split into individual cells. I definitely owed him one.
Nowadays, Excel has a Convert Text to Columns Wizard that easily let’s you take the text in one or more cells, and spread it out across multiple cells. Whew! What a god-send this is in order to split text into different cells – and so easy to use!