ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   remove line breaks in text strings (https://www.excelbanter.com/new-users-excel/124339-remove-line-breaks-text-strings.html)

Capn Swing

remove line breaks in text strings
 
I've imported an address list from outlook and the address 1 line has text
strings that have line breaks in them. The "column to text facility" will
only transfer the first line and won't let me input a return command under
"other" - does anyone have a solution?

Gary''s Student

remove line breaks in text strings
 
Edit Replace then click in the find what field and touch 010 in the
numerical keypad while holding down the ALT key.

Enter nothing in the replace field

Then click replace all
--
Gary's Student


"Capn Swing" wrote:

I've imported an address list from outlook and the address 1 line has text
strings that have line breaks in them. The "column to text facility" will
only transfer the first line and won't let me input a return command under
"other" - does anyone have a solution?



All times are GMT +1. The time now is 11:46 AM.

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