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
 

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

VBA- IF statement to replace cell contents 0
pull data from one table to another if multiple conditions are met 3
Using Sumproduct - Excel 2003 3
Help to create a macro 2
Columns 2
Grouping multiple data for one search 2
Extracting data from one column 3
How to copy the function SUM but offseted in 7 columns 2

Top