seperate two values fromone cell into 2 cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add two cells from seperate work sheets into a cell on seperate wo 6
How to seperate ALPHANUMERIC data in a cell in an excel sheet. 3
Question on breaking on cell into three seperate 1
demerge mercge cells 7
Excel Data pastes into 2 cells not 1 1
Need to combine multiple cells into on cell 8
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Update cell value based on name and specific date 1

Back
Top