Strip comma seperated cell content & insert into other c

[wisewood]

I have a column containing address information, comma seperated.

For each row, i want to extract the information from column B, and strip out the comma seperated information, and insert it into its own cell on that same row.

Eg.

50 The Street, The Locality, The Town, The Region, Post Code

Should be stripped out so that;

B = 50 The Street
C = The Locality
D = The Town
E = The Region
F = Post Code


However, some addresses may have fewer or more components, so it just needs to keep adding each component to the next column until there are no more components, then go to the next row and start again.

 

[VoG]

Try Data > Text to Columns and specify , as the delimiter.

 

[Norie]

Select the column, goto Data>Text to columns... and select comma as a delimiter.

The number of commas won't really matter unless you need to have specific types of data eg towns in a particular column.

 

[wisewood]

Great. Thanks.