How to split information in a cell

  • Thread starter Thread starter dcoates
  • Start date Start date
D

dcoates

:confused: I have a tip on how to Join first and last names, but how d
I split information that is in a cell into other cells. I have
spread sheet with over 26000 cells in a column that contains 5 words i
each cell. I want to split this information into 5 seperate cells ou
to the right of this column
 
Are the words separated by any unique method?

i.e. by a space or comma or similar.

If so, you could try Data>Text to Columns>Delimited by(enter your de-limiter)

Gord Dibben Excel MVP
 
My thanks to everyone's help. I did not know about the Data > Text to
columns. It worked fine.
 

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

splitting up information in a cell 1
Split cell based on uppercase letter 2
HELP! Split cell contents to new rows 7
Need to split a cell in a column 1
Splitting cells in Excel 2007 1
Split individual cells? 2
Splitting cell contents into 2 cells 1
Split cells across multiple columns 1

Back
Top