| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I remove line breaks from several cells?
I have imported labels (formatted as first/last name, address, city/state/zip
with line breaks between in each cell) and need utilize the "text to colums" in order to mail merge. How do I remove the line breaks so that the "text to colums" can recognize the delimiters? OR How do I get excel to recognize a line break as a delimiter? OR Any other suggestions to mail merge this information? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line Breaks in cells - Mac OS X Leopard | Excel Discussion (Misc queries) | |||
| Line breaks in my cells... | Excel Discussion (Misc queries) | |||
| Remove Manual Line Breaks in Cell | Excel Discussion (Misc queries) | |||
| remove line breaks in text strings | New Users to Excel | |||
| Remove Line Breaks ALT + ENTER | Excel Worksheet Functions | |||
Threaded Mode
