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.
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.