Thread: Separate data

Hi there...

this is probably pretty basic, but I have a list with two columns.

One has a name and the other one has an address.

Ex:

Column 1..................Column 2
James Patrick............2426 parson rd. some city, nj 93406

My question is this -

Can I take the second column and easily split off the street address, city, and zip into seperate columns?

Thanks so much for your help on this. Could be hours of tedium ahead. :\

Peter

Depends on how consistently the data is formatted. If it were always

street name[comma] city name[comma] ST zip

... then you could use Text to columns (see Help), split at commas, and then split the last column as spaces.

If not (like your example), it gets messy.