Seperate Data in Excel

[DanaPach]

Hello,

Another situation I need help with, I'm needing to seperate the following into 3 seperate fields, as opposed to one.

This is the current format-in one cell

Mesa, AZ 85204-6632

Need the City, State, and Zip seperated.
I have over 20,000 records to seperate and need a quick way to do so.

I would greatly appreciate any help in VB or macros.

Hello,

Another situation I need help with, I'm needing to seperate the following into 3 seperate fields, as opposed to one.

This is the current format-in one cell

Mesa, AZ 85204-6632

Need the City, State, and Zip seperated.
I have over 20,000 records to seperate and need a quick way to do so.

I would greatly appreciate any help.

Thank you

 

[SkipVought]

Dana,

This is fairly simple with the Data/Text to columns wizard in TWO STEPS

1) Parse on the COMMA -- this yeilds
[tt]
ColA ColB
Mesa AZ 85204-6632
[tt]
2) Parse on SPACE

In the Text to Columns wizard select delimited and then the appropriate parsing delimiter.



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[DanaPach]

Thanks Skip for all your help yesterday and today!!!!
Again I greatly appreciate it!!!!


Dana