Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
parseing out City, State ??
Hi Paul
Presuming your City Column is "B" starting at Row 5 type =RIGHT(B5,2) in"C" Column. Regards Cimjet "paul" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
parseing out City, State ??
Say Column C contains:
ATLANTA, GA Select the column and pull-down: Data Text to columns... delimited by comma -- Gary''s Student - gsnu2007g "paul" wrote: 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 |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
parseing out City, State ??
On Mar 25, 12:55*pm, paul wrote:
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 Add a column, then select the column. Data - Text to Columns - Delimited - comma is your delimiter. Cheers Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill a city and state from a zipcode | New Users to Excel | |||
City State Zip | Excel Discussion (Misc queries) | |||
City State Zip | Excel Worksheet Functions | |||
city, state, zip in same cell | Excel Discussion (Misc queries) | |||
Splitting City State Zip | Excel Worksheet Functions |