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

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Split single cell into multiple cells 2
Pasting a cell into bookmarked table from excel vba 1
Place picture in Excel cell 0
EXCEL: Separating data from 1 cell into multiple cells 5
How to separate contents of one cell into multiple horizontal cell 1
Linking data in MS Word into Excel 5
Combining three files when middle file has sections with endnotes 2

Top