Extract data from one column to three columns

  • Thread starter Thread starter Craig
  • Start date Start date
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
 
Back
Top