splitting a column

[scottwilsonx]

Hi all,

I have a column containing an address for each customer:
eg: "1 high street, wimbledon, london, sw19 1hg".

I want to be able to create 4 columns from this data, first showing th
street, second the area, third the town and 4th the postcode.

Assuming that each of these are in the same section of the origna
formula, eg: before 1st comma, after 1st comma, after 2nd comma etc, i
there a way to do this ?!

Thanks in advance for your help.

Scot

 

[JulieD]

Hi Scott

have a look at data / text to columns
to use it firstly ensure that you have at least three blank columns to the
right of your existing list
select your list
choose data / text to columns
choose delimited - click Next
untick tab, tick comma
click finish

this should give you what you want.

Cheers
JulieD

 

[Domenic]

Hi Scott,

You can use "Text to Columns" to do this, and use "Comma" and "Space
as your delimiters.

Data > Text to Columns
Check "Delimited"
Click Next
Check "Comma" and "Space" as your delimiters
Check "Treat consecutive delimiters as one"
Click Finish

Hope this helps

 

[scottwilsonx]

Thanks Dominec and JulieD.

Scott