Text to Columns Question

[Luck]

I am working in a spreadsheet where there are multiple entries in one cell that I wish to move into the adjacent columns. My problem is that the data is inserted into the cell in a particularly weird manner. Each cell contains no delimiter between entries (not even a space) because the entries were copy and pasted from a website with some kind of "interesting" formatting.

I was hoping someone was aware of a way to separate these entries. I have attached the document where I am working in the "companies" sheet, in column K. Again, I wish to expand the entries of each cell into columns L, M, N, etc.

Edit: For clarity, the entries in each cell are placed on different "rows." When viewing each cell in the formula bar, it displays the first entry and upon hitting the down arrow key, reveals the next "row" in the cell.

Thanks in advance!

[solnajeff]

Hi

Your attachment does not show up, please upload again.

Regards


Jeff

(for some reason your post shows up twice and the other post has the file)

[teylyn]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.