How to Fix PDF Text Pasting as Question Marks or Garbled Characters
Question details
The user needs to copy text or numbers from a PDF document into Word or Excel, but the pasted content appears as unreadable symbols instead of the actual text.
- Product
- Device & OS
- not provided
- Scenario
- Extracting and copying text content from a PDF document to paste into a spreadsheet or word processor.
- Observed behavior
- When pasting the copied content, it displays as square boxes, question marks, or garbled characters instead of readable letters and numbers.
Ensure the source PDF is not password-protected against copying, and try pasting the text into a plain text editor like Notepad first to strip away any application-specific formatting issues.
Perform Optical Character Recognition (OCR) on the PDF
Running OCR rebuilds the text layer, allowing you to bypass broken font mappings and copy the text accurately.
Garbled text usually happens because the PDF has a custom embedded font without a proper Unicode character map. Your computer can display the shapes but doesn't know what letters they represent. OCR analyzes the visual characters and creates a brand-new, readable text layer.
Launch your advanced PDF application (such as Acrobat DC or WPS PDF) and locate the OCR or 'Recognize Text' tool.
Select the option to recognize text in the document. Ensure you set the correct language matching the document's content before starting the scan.
Once the OCR process is complete, highlight the newly generated text layer, copy it (Ctrl+C), and paste it into Word or Excel.
Copy Text Using an Alternative PDF Viewer
Different PDF applications handle font encoding differently. Opening the file in another program might resolve the copying issue.
Request the Creator to Regenerate the PDF
If the document was exported improperly, the original author can fix the issue by embedding fonts correctly during PDF creation.
Use WPS PDF to Extract Text Accurately
WPS Office includes a powerful PDF editor with advanced OCR and conversion tools. You can easily extract text from poorly encoded PDFs without worrying about garbled characters, and directly convert PDFs to editable Word or Excel documents.
- 1. Open the PDF in WPS Office: Launch WPS Office and open your problematic PDF file in the application.
- 2. Access Conversion Tools: Navigate to the 'Tools' tab on the top ribbon and select 'PDF to Word' or 'PDF to Excel' depending on your needs.
- 3. Enable OCR Settings: In the conversion dialog, select the OCR option if the text is heavily encoded or scanned, ensuring accurate text recognition.
- 4. Convert and Copy: Click 'Convert' to generate the new document. You can now easily copy, paste, or edit the text with perfect formatting.
Frequently Asked Questions
Why does PDF text paste as weird symbols or boxes?
This occurs when the PDF creator embeds a custom font without a proper character map (Unicode mapping). Your computer knows what the font looks like visually but doesn't know what actual letters or numbers those shapes represent when extracted.
Can I fix garbled PDF text without downloading new software?
Yes, you can upload the PDF to Google Drive, right-click it, and select 'Open with Google Docs'. Google Docs will automatically run a basic OCR process and extract the text, which you can then copy without the garbled characters.
Does 'Print to PDF' fix the text encoding issue?
Sometimes, using the 'Print to PDF' function flattens the document and creates a new visual layer. However, if the text layer is fundamentally broken, simply reprinting it won't fix the mapping. You will usually need to run an OCR tool on the newly printed PDF to make it copyable.
