Mac equivalent of ALT+010 for Windows (Replace Carriage Return/Line Breaks) I'm trying to do a find and replace in Excel 2016 for Mac, to replace all line breaks with a space.

On Windows I'd do CTRL+R for find and replace, then hold the alt key and type 010 which would insert a linebreak into the find field.

I'd then type a Space, and it hit Replace All.

I can't seem to workout how to do the keyboard equivalent on a Mac?

Any suggestions.
In most macOS applications ControlEnter works, and in Excel ControlAltEnter works in cells, and even in Find and Replace it will enter a space, but it doesn't appear to search.

Similarly \n which is an escaped new line doesn't work, nor does copying and pasting a new line character from another application.

In word ^p works as an escape character but again not in Excel.

It looks very much like this isn't possible in Excel for Mac. The best thing I could suggest at this point is to ask for Microsoft to fix this via their feedback forum:

https://excel.uservoice.com/

The last option I was going to suggest was using Numbers which is the Apple version of Excel, it works very well in general but has the same limitation from my testing.

Last option would be to use Excel for Windows via a Remote Desktop application like Citrix, a simulator like WINE or a virtual machine like VirtualBox, Parallels or VMWare.