Split cell with comma, into new worksheet
 

Hi

I am trying to do a text - column format but to pull into a new sheet.

e.g.

In DWH Dump A13 = Nokia, 6230

I want it to pull 'Nokia' into Sheet 1 A11 and '6230' into Sheet 1 B11.

If you can help, I would be grateful.

Many Thanks,

Greg

Split cell with comma, into new worksheet
 

Select your range (only works if the cells are in a single column)
data|text to columns
delimited
by commas

and finish up the wizard.

But I'm not sure how a new worksheet fits in???

Maybe copy to a new worksheet first, then do the work????

Greg wrote:

Hi

I am trying to do a text - column format but to pull into a new sheet.

e.g.

In DWH Dump A13 = Nokia, 6230

I want it to pull 'Nokia' into Sheet 1 A11 and '6230' into Sheet 1 B11.

If you can help, I would be grateful.

Many Thanks,

Greg

--

Dave Peterson