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
|