ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cut and Paste Text with CRLF into Single Cell (https://www.excelbanter.com/excel-discussion-misc-queries/172500-cut-paste-text-crlf-into-single-cell.html)

Jim

Cut and Paste Text with CRLF into Single Cell
 
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?
--
Jim

Dave Peterson

Cut and Paste Text with CRLF into Single Cell
 
Maybe you can paste directly into the formulabar.

Jim wrote:

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?
--
Jim


--

Dave Peterson


All times are GMT +1. The time now is 12:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com