Sometimes you may need data from a spreadsheet where the original owner used line breaks to separate the data within a cell. Perhaps you need that data, but without the line breaks. You can simply go to the "edit" menu, and choose "Find and Replace". From there, just type \r\n|\n|\r in the "find" box, and in the replace box type a comma, then a space. Click to select "Search using regular expressions" (which automatically selects "Match case"). Be sure you have selected where you want it to search (All sheets, This sheet, or Specific range) and then click "Replace all" - Voilà! All of the cells that previously included line breaks will have them all removed!
top of page
bottom of page