| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
seperate two values fromone cell into 2 cells
I was asked by a friend: he opened a very big file (no access to the origin
one any more) in excel and now he noticed that in some cells the data were not seperated properly like in a cell it is; 10 23 while it should be 10 in one cell and 23 in next cell. Is there anything to help him out? he has many cells in his file like this. appreciate any help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
seperate two values fromone cell into 2 cells
Take a look at Text-to-columns
Select the single column range of values Then...From the Excel main menu: <data<text-to-columns Check: Delimited.....click [next] Check: Space.........click [finish] If that doesn't work.....post back with more details (and samples) of the data (with that method....UNDO is your friend) Does that help? *********** Regards, Ron XL2002, WinXP "Darius" wrote: I was asked by a friend: he opened a very big file (no access to the origin one any more) in excel and now he noticed that in some cells the data were not seperated properly like in a cell it is; 10 23 while it should be 10 in one cell and 23 in next cell. Is there anything to help him out? he has many cells in his file like this. appreciate any help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
seperate two values fromone cell into 2 cells
Data/Text to Columns...
In article , Darius wrote: I was asked by a friend: he opened a very big file (no access to the origin one any more) in excel and now he noticed that in some cells the data were not seperated properly like in a cell it is; 10 23 while it should be 10 in one cell and 23 in next cell. Is there anything to help him out? he has many cells in his file like this. appreciate any help |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
seperate two values fromone cell into 2 cells
thnaks, perfectly works.
"Ron Coderre" wrote: Take a look at Text-to-columns Select the single column range of values Then...From the Excel main menu: <data<text-to-columns Check: Delimited.....click [next] Check: Space.........click [finish] If that doesn't work.....post back with more details (and samples) of the data (with that method....UNDO is your friend) Does that help? *********** Regards, Ron XL2002, WinXP "Darius" wrote: I was asked by a friend: he opened a very big file (no access to the origin one any more) in excel and now he noticed that in some cells the data were not seperated properly like in a cell it is; 10 23 while it should be 10 in one cell and 23 in next cell. Is there anything to help him out? he has many cells in his file like this. appreciate any help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to seperate a text group in once cell into many cells | Excel Discussion (Misc queries) | |||
| Seperate cell string into individual cells | Excel Worksheet Functions | |||
| How to seperate 2 values to 2 different cells | Excel Discussion (Misc queries) | |||
| How can I look up two seperate values/cells and return the value . | Excel Worksheet Functions | |||
| Using the results from two seperate cells to create cell reference | Excel Worksheet Functions | |||
Linear Mode
