Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link worksheet A & B | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
fill cell with color from other worksheet | Excel Discussion (Misc queries) | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) |