Spliting field on a "," 2

[YNOTU]

Dear all, I have an excel sheet with 37,000 records where one field contains city, state and zip and I need to split this field into their own fields (city - state - zip).

It appears every records is formatted as follows:

123 Main Street, City, State ZIP

How can I split the field when two coma's are present?

Thanks

 

[EBGreen]

Look at the Split() function.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[AnotherHiggins]

Have a look at Data > Text to Columns

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[YNOTU]

Both worked great. Data > Text to Columns was so simple. I feel dumb.


Thank you very much guys

 

[EBGreen]

As do I...that is a better solution.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[AnotherHiggins]

Don't worry about it. There's nothing dumb about asking questions and learning.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.