Find And Replace to Add Line Breaks within Cells

I have Excel for Mac.  Found this answer is an old thread. It worked.:

But use CHAR(10) if you want a line break:

ie.  B1: =SUBSTITUTE(A1,"$$",CHAR(10)). 
will replace $$ with a line break in the new column

The simplest way (though with a large spreadsheet, it may still not be simple) is to insert a blank column next to cells containing line breaks. In that column (say, column B), enter

B1: =SUBSTITUTE(A1,CHAR(13),"")

or

B1: =SUBSTITUTE(A1,CHAR(13)," ")

depending on whether you want to keep a space between the end of one line and the beginning of another.

Copy down as far as required. Select the column. Copy it. Select the original column. Choose Edit/Paste Special, selecting the Values radio button.

Delete the column you inserted.

https://learn.microsoft.com/en-us/answers/questions/4770312/how-can-i-find-replace-line-breaks-in-mac-2008-exc?forum=msoffice-all&referrer=answers

I have Excel for Mac.  Found this answer is an old thread. It worked.:

The simplest way (though with a large spreadsheet, it may still not be simple) is to insert a blank column next to cells containing line breaks. In that column (say, column B), enter

B1: =SUBSTITUTE(A1,CHAR(13),"")

or

B1: =SUBSTITUTE(A1,CHAR(13)," ")

depending on whether you want to keep a space between the end of one line and the beginning of another.

Copy down as far as required. Select the column. Copy it. Select the original column. Choose Edit/Paste Special, selecting the Values radio button.

Delete the column you inserted.

https://learn.microsoft.com/en-us/answers/questions/4770312/how-can-i-find-replace-line-breaks-in-mac-2008-exc?forum=msoffice-all&referrer=answers

RobertR2060 

Sorry, no idea.