View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fat Doris Fat Doris is offline
external usenet poster
 
Posts: 1
Default Replacing spaces with a line end

How can I replace two spaces with a line end, throughout one column in a
spreadsheet. The context is that in one column the entire address has been
entered in one cell without line breaks, and I need to use that column in a
mailmerge so want the address to print as normal on different lines.

Thank you