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
|