Convert Curly Apostrophes to Straight Apostrophes in Word and Excel
Question details
The user needs to prevent or replace curly apostrophes so text can be imported into an email database or Excel.

- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- Preparing Word text or Excel data for import into an email database.
- Observed behavior
- Word may automatically change straight apostrophes to curly apostrophes, which can cause compatibility problems during import.
Identify whether you need to change existing text, prevent future substitutions, or both. Copy a curly apostrophe from the affected text so you can use the exact character in Find and Replace.
Turn off smart quotes for new text in Word
Use this setting to keep newly typed apostrophes straight in Word.
In Word for Windows, select File > Options > Proofing.
Select AutoCorrect Options, then open the AutoFormat As You Type tab.
Clear the Straight quotes with smart quotes checkbox, then select OK to close the dialogs.
Replace existing curly apostrophes in Word or Excel
Use Find and Replace to convert apostrophes already present in a document or worksheet.
Replace Curly Apostrophes in WPS Writer or Spreadsheets
Use Find and Replace in WPS Writer or WPS Spreadsheets to convert existing curly apostrophes before sharing or importing your text.
- 1. Open the file: Open your document in WPS Writer or your workbook in WPS Spreadsheets.
- 2. Open Replace: Press Ctrl+H to open Find and Replace.
- 3. Enter the apostrophes: Enter ’ in the Find field and ' in the Replace field.
- 4. Replace and review: Select Replace All and review the results. Repeat with ‘ in the Find field if that character also needs replacing.

Frequently Asked Questions
Why does Word change my straight apostrophes to curly ones?
Word's AutoFormat As You Type setting can replace straight quotes with smart quotes. In Word for Windows, change it under File > Options > Proofing > AutoCorrect Options.
Will turning off smart quotes fix apostrophes already in my document?
No. Press Ctrl+H in Word and replace each curly apostrophe character with a straight apostrophe.
How can I replace curly apostrophes in an Excel worksheet?
Open the worksheet, press Ctrl+H, enter ’ in Find what and ' in Replace with, and select Replace All. Repeat for ‘ if needed, then check the affected cells.
Why is a straight apostrophe missing at the start of an Excel cell?
Excel may interpret a leading apostrophe as a marker that makes the entry text, rather than displaying it as a character. Check the cell contents and the imported output when a leading apostrophe must be preserved.




