Reverse Concatenate

[Ian Morrin]

Hi,

I have a worksheet in Excel that contains address and tel numbers etc. the
address are contained in one column and each part of the address (road name,
city, county, post code etc) are separated by commas.

Is there a way to get these items into individual cells, a reverse
Concatenate so to speak?

Thanks

Ian

 

[macropod]

As in Text to Columns, via the Data Menu?

Cheers

 

[Ian Morrin]

So simple when you know how! thanks