How to replace newline in Excel for Mac As it seems there are suggestions for how to replace a character or a string with newline in Excel for Mac, like this one. But trying to reverse the process does not work; e.g., to type CTRL+J or ALT+0010 etc. Any advice on how to replace newlines in cells with, for example, space?
Solution for some cases could be:
Copy cell(s) (⌘ + C), paste special (⌃ + ⌘ + V), select 'Values', click 'OK'
Caveats: there must be space at the end of line, otherwise there will be no separation between lines (it removes newline but doesn't replace); it doesn't work in-cell (source and destination cells must be different)