splitting a column

  • Thread starter Thread starter scottwilsonx
  • Start date Start date
S

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
 
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
 
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
 
Back
Top