Concatenate function

[pboost1]

Hello everybody. I know that the Concatenate function joins several text strings into one text string, and I have used that funtion many times. Now I need a way to do the opposite. I need to take one text string and break it into several text strings, each value getting one cell. Thank you for any help you provide.

[Norie]

There are various ways to do this - it really depends on the text you wsant to split up.

One method is to goto Data>Text To Columns... and follow the wizard.

Another would be to use worksheet functions like MID, LEFT, RIGHT, FIND etc