Extract data from one column to three columns

C

Craig

Hi,

I would like to extract information from one column and
put it into three columns:

Sample Data:

A1
Rochester, NY 14621

Desired Result:

B1
Rochester

C1
NY

D1
14621

Thanks!

Craig
 
F

Frank Kabel

Hi
select the column and goto 'Data - Text to columns' and choose a valid
delimiter
 
Top