Excel For Mac Show Find And Replace

I'm using Excel 2007 and trying to replace about 2000 commas with full stops. I want to use find and replace but keep getting a message saying that Excel cannot find the data I'm searching for. Excel help suggests I haven't clicked on 'find' before clicking 'replace' but I did.

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?

Plugins for mac calendar. Edited by moderator: email address removed. Please remove your email address from your post, unless you really like getting spamed. There are little bots that troll the web looking in open forums for emails address's Use the edit button in the upper right corner. Sorry, don't know that much about Mac's In Windows the key sequence is: ALT + ENTER and I believe that the command for Mac's is: CONTROL+OPTION+RETURN Do not know if the Mac's search & replace will accept the key sequence. The =CHAR() function could also be used.

Best minecraft 1.8 mods. In Windows it is =CHAR(10) In Mac's I believe it is =CHAR(13) MIKE.