Hi all, I have a document with over 1,000 subtitles for a film (I have it in both Word and Excel versions). Most of the subtitles have 2 lines, which are separated with this character: In Word (Windows or Mac), I can easily replace all the with a line break (^p).
![Alt Alt](https://tr2.cbsistatic.com/hub/i/r/2017/11/30/ddcdccbe-9c7d-4242-a4a2-6364cf2f6aa9/resize/770x/f9794fde7c034bec5f0640b2ff7093bb/exceldevelopertab.jpg)
How can I do it in Excel for Mac? Is there a way to represent the line break within the Excel “Replace” tool, just like ^p in the Word “Replace” tool? Or is there a way to paste a Word table (which has line breaks within the table cells) into Excel, keeping the line breaks?
Under Office for Mac (Excel specifcally), ALT key is probably replaced by the Command/Apple key which is just beside it, this would conform more tightly with general Mac shortcuts, for instance, Paste on the Mac is Command+V.