Posted to microsoft.public.excel.misc,microsoft.public.excel.programming

external usenet poster

Posts: 11

parseing out City, State ??

I have a file like this

Name Address City State ZIP
Zimmer 221 W 10 ATLANTA, GA 11111

So the CITY field contains both the City and a comma, state

How can I easily go through my 5,000 records and move the State to the
actual STATE field in excel?

thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
parseing out City, State ??	paul	Excel Discussion (Misc queries)	3	March 25th 08 05:08 PM
City State Zip	Texas Nuckols	Excel Discussion (Misc queries)	3	August 7th 07 10:56 PM
City State Zip	Texas Nuckols	Excel Worksheet Functions	3	August 7th 07 10:22 PM
identify city, state zip	Dave B[_3_]	Excel Programming	2	September 17th 05 03:16 PM
city, state, zip in same cell	whs2002	Excel Discussion (Misc queries)	2	April 29th 05 07:02 AM

All times are GMT +1. The time now is 02:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us