parseing out City, State ??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

paul - 25 Mar 2008 17:55 GMT

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 to this Message

Cimjet - 25 Mar 2008 18:05 GMT

Hi Paul
Presuming your City Column is "B" starting at Row 5 type =RIGHT(B5,2) in"C"
Column.
Regards
Cimjet

>I have a file like this
>
[quoted text clipped - 7 lines]
>
> thanks

Reply to this Message

Gary''s Student - 25 Mar 2008 18:06 GMT

Say Column C contains:

ATLANTA, GA

Select the column and pull-down:

Data > Text to columns... > delimited by comma

Signature

Gary''s Student - gsnu2007g

> I have a file like this
>
[quoted text clipped - 7 lines]
>
> thanks

Reply to this Message

cht13er - 25 Mar 2008 18:08 GMT

> I have a file like this
>
[quoted text clipped - 7 lines]
>
> thanks

Add a column, then select the column.
Data -> Text to Columns -> Delimited -> comma is your delimiter.

Cheers

Chris

Reply to this Message