seperate two values fromone cell into 2 cells

D

Darius

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
 
R

Ron Coderre

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
 
D

Darius

thnaks, perfectly works.


Ron Coderre said:
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 said:
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
Click to expand...
Click to expand...
 
Top