| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to split the cell containt
hi all,
I have a column with 100 enteries....the entries are as "abc sdf sdsd" here i would like to copy tthis cell entities in to next three cells by spliting at space between two words |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to split the cell containt
Look at Data=Text to Columns.
"anil" wrote: hi all, I have a column with 100 enteries....the entries are as "abc sdf sdsd" here i would like to copy tthis cell entities in to next three cells by spliting at space between two words |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split a cell diagonally in excell - a calendar -2 dates in 1 cell | Excel Discussion (Misc queries) | |||
| How can I split one cell into two cell parts (upper & lower)? | Excel Discussion (Misc queries) | |||
| Split one cell into many | Excel Worksheet Functions | |||
| I want to split containt of a cell and copy in seprate cells | Excel Worksheet Functions | |||
| how do you split a cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
