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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging multiple columns into one column (dynamically) 1
Columns 2
pull data from one table to another if multiple conditions are met 3
Extracting data from one column 3
VBA- IF statement to replace cell contents 0
Using Sumproduct - Excel 2003 3
Help to create a macro 2
Grouping multiple data for one search 2

Back
Top