Pasting into One Column

[Kevin K Fosler]

I have some text with tab characters that I would like to paste into one
column. When I paste the text, it puts the text into multiple columns. How
can I paste it all into one column?

Thanks,
Kevin Fosler

 

[Steven Bitaxi]

Save it as a text document, open it with Excel, select Delimited,
de-select the tab - set it to comma or click other and enter an % or
some other character that doesn't appear in your document. It will open
it with all you data in one, it will just require a little clean up.
Just use the following formula in column B
=CLEAN(A1)

and copy it down to the end of your text. You can then copy from column
B and Paste Special...Values into your other document.

Sounds like more work, but it is pretty quick to do.