Cut and Paste Text with CRLF into Single Cell

J

Jim

I am trying to cut and paste text that includes carriage return-line feed
characters in the middle into a single spreadsheet cell. When I do this now
I get portions of the text split apart into multiple rows in a column. In
other words I want Excel to convert CR-LF into Alt-Enter when pasting the
text. Is that possible?
 
D

Dave Peterson

Maybe you can paste directly into the formulabar.
I am trying to cut and paste text that includes carriage return-line feed
characters in the middle into a single spreadsheet cell. When I do this now
I get portions of the text split apart into multiple rows in a column. In
other words I want Excel to convert CR-LF into Alt-Enter when pasting the
text. Is that possible?
Click to expand...
 

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

Cut & Paste in Excel without erasing cell borders? 1
Transforming data in column into a linear text string 2
Wrap text is tempermental within a single cell 2
Incomplete text wrap within a single cell 1
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Pasting mutiple paragraph text into a single cell 2
Cut and Paste 2
paste copied text to only one cell 4

Top