Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
How do I use a formula to create a new line of text in a cell? | Excel Worksheet Functions | |||
Remove Specific Text - HELP! | Excel Worksheet Functions | |||
Hyperlink in cell with line breaks | Excel Discussion (Misc queries) | |||
Remove text leading zero in text string | Excel Worksheet Functions |