How to split information in a cell

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
 
G

Gord Dibben

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
 
D

dcoates

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
Is it possible to split 1 cell into 3 cells w/o affecting other ce 1
Is there any way to split contents of a cell into more cells. 2
cell data management 2
Need to split a cell in a column 1
Formula To Split Name 5
Split Cells 2
Color formatting in cell $An 3

Top