Formatting Issues

Convert Curly Apostrophes to Straight Apostrophes in Word and Excel

Camila MilosovichCamila Milosovich Nov 20, 2026 868 views

Question details

The user needs to prevent or replace curly apostrophes so text can be imported into an email database or Excel.

Convert Curly Apostrophes to Straight Apostrophes in Word and 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.
Before you start

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.

Solution 1Recommended

Turn off smart quotes for new text in Word

Use this setting to keep newly typed apostrophes straight in Word.

1
Open Word options

In Word for Windows, select File > Options > Proofing.

2
Open AutoCorrect settings

Select AutoCorrect Options, then open the AutoFormat As You Type tab.

3
Disable smart quotes

Clear the Straight quotes with smart quotes checkbox, then select OK to close the dialogs.

Existing text is unchanged: This setting affects future typing in Word. Use Find and Replace to change apostrophes already in a document or worksheet.
Replace apostrophes in WPS Office

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. 1. Open the file: Open your document in WPS Writer or your workbook in WPS Spreadsheets.
  2. 2. Open Replace: Press Ctrl+H to open Find and Replace.
  3. 3. Enter the apostrophes: Enter ’ in the Find field and ' in the Replace field.
  4. 4. Replace and review: Select Replace All and review the results. Repeat with ‘ in the Find field if that character also needs replacing.
Replace curly apostrophes throughout a document or worksheetWork with Microsoft Word DOCX and Excel XLSX filesUse a familiar Find and Replace workflowEdit documents and spreadsheets in one office suite
microsoft office alternative - wps office

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.