View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JR JR is offline
external usenet poster
 
Posts: 92
Default 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?