Nov 03, 2018  I am currently using Office 2013 excel and Parallels. Working on an array formula but I cannot figure the CTRL SHIFT ENTER on this keyboard. Excel file format converter for mac. Using mac book pro This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

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). 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?