Extract data from a Cell

J

Johnny

Is there a way to read a cell, which it contains:
The range is from A1...A3700+

City_Name, State/Country (code)
for example: Ontario, CA (XYK)
Some of them don't have the State, but Country.

and put them in each separated column into a new excel file.

Thanks all for your help.

Johnny
 
C

CLR

It will probably take a little sorting and hand-massaging as well, but the
Data > Text to columns feature should help you a long ways......

Vaya con Dios,
Chuck, CABGx3
 
J

Johnny

Gracias amigo.


CLR said:
It will probably take a little sorting and hand-massaging as well, but the
Data > Text to columns feature should help you a long ways......

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Top