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

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

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

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