SOLVED

Replacing curly quotes with straight quotes

%3CLINGO-SUB%20id%3D%22lingo-sub-3504026%22%20slang%3D%22en-US%22%3EReplacing%20curly%20quotes%20with%20straight%20quotes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3504026%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20know%20how%20to%20replace%20curly%20quotes%20with%20straight%20quotes%20in%20Excel%3F%20I'd%20be%20very%20happy%20if%20someone%20can%20tell%20me%20how!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3504026%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3504136%22%20slang%3D%22en-US%22%3ERe%3A%20Replacing%20curly%20quotes%20with%20straight%20quotes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3504136%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1423515%22%20target%3D%22_blank%22%3E%40VMSParker-Fine-Art%3C%2FA%3E%26nbsp%3BWhich%20platform%20are%20you%20on%3F%20Which%20key(s)%20do%20you%20press%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3504194%22%20slang%3D%22en-US%22%3ERe%3A%20Replacing%20curly%20quotes%20with%20straight%20quotes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3504194%22%20slang%3D%22en-US%22%3EHi%2C%20thanks%20for%20taking%20the%20time%20to%20reply.%20I've%20got%20an%20Excel%20spreadsheet%20which%20has%20lots%20of%20data%20in%20it%20including%20curly%20speech%20marks.%20I%20need%20to%20upload%20the%20spreadsheet%20to%20a%20platform%20-%20but%20when%20I%20do%2C%20all%20the%20curly%20quotes%20get%20replaced%20with%20squares.%20I%20know%20it%20works%20fine%20with%20straight%20quotes%20I%20but%20can't%20see%20how%20to%20replace%20them%20in%20Excel.%20Find%20and%20replace%20replaces%20literally%20every%20letter%20and%20punctuation%20mark%20with%20speech%20marks!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3504239%22%20slang%3D%22en-US%22%3ERe%3A%20Replacing%20curly%20quotes%20with%20straight%20quotes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3504239%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1423515%22%20target%3D%22_blank%22%3E%40VMSParker-Fine-Art%3C%2FA%3E%26nbsp%3BCopy%20a%20curly%20quote%20first.%20Then%20paste%20it%20in%20the%20Find%20field%20and%20type%20a%20regular%20quote%20in%20the%20Replace%20with%20filed.%20That%20should%20only%20replace%20curly%20brackets%2C%20not%20all%20letters%20and%20punctuation.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3504428%22%20slang%3D%22en-US%22%3ERe%3A%20Replacing%20curly%20quotes%20with%20straight%20quotes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3504428%22%20slang%3D%22en-US%22%3EAMAZING!!%20Thank%20you%20so%20much.%20Copying%20and%20pasting%20the%20speech%20marked%20into%20Find%20and%20Replace%20worked%20a%20treat!%3C%2FLINGO-BODY%3E
New Contributor

Does anyone know how to replace curly quotes with straight quotes in Excel? I'd be very happy if someone can tell me how!

 

Thank you

4 Replies

@VMSParker-Fine-Art Which platform are you on? Which key(s) do you press?

Hi, thanks for taking the time to reply. I've got an Excel spreadsheet which has lots of data in it including curly speech marks. I need to upload the spreadsheet to a platform - but when I do, all the curly quotes get replaced with squares. I know it works fine with straight quotes I but can't see how to replace them in Excel. Find and replace replaces literally every letter and punctuation mark with speech marks!
best response confirmed by VMSParker-Fine-Art (New Contributor)
Solution

@VMSParker-Fine-Art Copy a curly quote first. Then paste it in the Find field and type a regular quote in the Replace with filed. That should only replace curly brackets, not all letters and punctuation. 

AMAZING!! Thank you so much. Copying and pasting the speech marked into Find and Replace worked a treat!