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

Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Linking data in MS Word into Excel 5
Problem with CR LF and Text Box (Access) 0
Transforming data in column into a linear text string 2
Wrap text is tempermental within a single cell 2
Merge Cell Cut & Paste 1
How do you paste a list of bulleted text from a word doc. into exc 2
Incomplete text wrap within a single cell 1

Top