Commands

[gaxtell]

Is there a way to easily take data in a single cell (city, st zip for
example) and separate it into three separate cells?

I use =right(XX,7) for the zip, etc. but the city is all different
width and the "right" "left" command does not cut the info, it just
copies to the new cell.

Thanks!

 

[Louise]

The command is DATA/Text to Columns, using the Delimited option (chances are your cities are all different lengths).
Make sure you have blank cells next to the column containing the data you want to separate.
You'll probably have to do it twice. Once indicating a comma delimiter to separate City from State, then the second time indicating a space delimiter to separate State from Zip.

HTH
Louise

 

[gaxtell]

Thanks Louise!!! I'll give it a try!

I knew there must be a way.

Gene

 

[Louise C.]

Happy to oblige.

Louise
~ Give a man a fish and he'll eat for a day.
~ Teach a man to fish and he'll eat for a lifetime.