Cell Data Issue

[VQCHEESE]

I have a problem a client sent me an excel doc with names and addresses

in Column E the header is city/state/zip

i would like to break that out into 3 seperate columns city in E, state in F and zip in G

heres an example how the orginal data came in ColumnE
Goldendale, WA, 98620-

Does anyone have a quick way to do this.

thanks

 

[Andrew Poulsom]

You can try Data|Text To Columns with comma as the delimiter.

 

[VoG]

Select the data, Data > Text to columns, select Delimited and , as the delimiter.

 

[look]

Hi VQCheese,

Use the text to column feature on Excel. Data >>Text to Column>> use delimited >> use space to separate data.

Thanks