Forum Discussion
Ilookmarvlus
Jun 16, 2023Copper Contributor
Replacing Line Feeds in Cells
I have been struggling with accomplishing something ever so easy in Word and other applications like Apple Numbers. I have a huge spreadsheet over 800 pages long and most of the length is the res...
Riny_van_Eekelen
Jun 17, 2023Platinum Contributor
Ilookmarvlus All the tutorials you find on-line speak of using Find & Replace and then find Ctrl-J and replace it with a space. But, unfortunately that doesn't work in Excel for the Mac.
The easiest way to address this is to use a separate column and the SUBSTITUTE function as demonstrated in the picture below.
Copy it down, copy and paste values from column B on top of itself and delete column A.