Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
split data
I have some data in a column that i need to split in 2 colums. eg..
column a 10 apples 5 peaches 7 books have to make it like : column a column b 10 apples 5 peaches 7 books any way i can do tht? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
split data
Look at Data=Text to Columns
"swati" wrote: I have some data in a column that i need to split in 2 colums. eg.. column a 10 apples 5 peaches 7 books have to make it like : column a column b 10 apples 5 peaches 7 books any way i can do tht? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
split data
=LEFT(A1,FIND(" ",A1,1)-1)*1
=MID(A1,FIND(" ",A1,1)+1,99) Vaya con Dios, Chuck, CABGx3 "swati" wrote: I have some data in a column that i need to split in 2 colums. eg.. column a 10 apples 5 peaches 7 books have to make it like : column a column b 10 apples 5 peaches 7 books any way i can do tht? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
split data
Hi,
Do the following: 1. Select the column where you have this text. 2. On the Data menu, click Text to Cloumn. The Convert Text to Cloumns wizard dialog box is diaplyed. 3. In the Convert Text to Cloumns wizard step 1-3, click Fixed Width under the "Choose the file type that describes you data", . 4. Click Next 5. In the Convert Text to Cloumns wizard step 2-3, adjust the scale int the "Data prview" section and place the scale pointer between the number and the Words. 6. Click Next. 7. In the Convert Text to Cloumns wizard step 3-3, displays how the data would be seperated. 8. Click Finish. The data is is seperated in to two columns. Challa Prabhu "swati" wrote: I have some data in a column that i need to split in 2 colums. eg.. column a 10 apples 5 peaches 7 books have to make it like : column a column b 10 apples 5 peaches 7 books any way i can do tht? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I split my data into ranges | Excel Worksheet Functions | |||
Split data in a cell | Excel Worksheet Functions | |||
Split data into new sheets | Excel Discussion (Misc queries) | |||
how to split data into columns and arrange the resulting data | Excel Discussion (Misc queries) | |||
Split data in column | Excel Worksheet Functions |