I wish to separate city, state, and zip into 3 separate columns

C

CLR

Try Data > TextToColumns > Delimited, using a space or whatever character
exists between the strings as the delimiter......

Vaya con Dios,
Chuck, CABGx3
 
Top