seperate two values fromone cell into 2 cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Darius - 13 Feb 2007 16:07 GMT

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 to this Message

Ron Coderre - 13 Feb 2007 16:24 GMT

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

> 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
[quoted text clipped - 4 lines]
>
> appreciate any help

Reply to this Message

Darius - 13 Feb 2007 17:02 GMT

thnaks, perfectly works.

> Take a look at Text-to-columns
>
[quoted text clipped - 24 lines]
> >
> > appreciate any help

Reply to this Message

JE McGimpsey - 13 Feb 2007 16:26 GMT

Data/Text to Columns...

Reply to this Message