separate one cell into several cells

M

martin whiting

I have a spreadsheet report generated by a survey software package, and it
has placed many answers for different questions into one cell in excel.
These answers are separated by a colon.

is it possible to "find and replace" in someway so that i can separate out
the cells with words with colons between them, into several cells?

Sorry this sounds confused, it is hard to explain. but basically i have
cells like,

Tree:plant:grass:house
all in one cell.

but i want each of these words in a different cell.
 

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

EXCEL: Separating data from 1 cell into multiple cells 5
How to separate contents of one cell into multiple horizontal cell 1
Separating carriage return data into separate cells 2
Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells 1
Splitting cell contents into 2 cells 1
Separate one cell into 11 1
Separate One Cell Into Many Rows 2
Separate Cells 5

Top