Data Import & Export

How to Fix Excel Pasting Symbols Instead of Copied Text

Algirdas Jasaitis Sep 28, 2026 872 views

Question details

Users experience copied text from an Excel macro pasting as symbols, question marks, boxes, or X characters in the target application.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Using an Excel form macro to copy vehicle information to the clipboard and pasting it into another destination.
Observed behavior: The pasted text renders as unreadable symbols, question marks, or boxes instead of the expected alphanumeric characters.

Before you start

Before troubleshooting, try manually selecting and copying the text (Ctrl+C) instead of using the macro copy button to isolate whether the issue lies in the VBA code or the system clipboard.

Solution 1Recommended

Check Regional and Language Encoding Settings

Character encoding mismatches between the source and target systems often cause text to render as question marks or boxes.

Different applications and operating system environments interpret clipboard data based on their local encoding settings. If the affected user's computer is set to a different region or non-Unicode language setting compared to unaffected users, the clipboard data may become corrupted during transfer.

Open System Region Settings

Search for and open the 'Control Panel' in Windows, then navigate to 'Clock and Region' and select 'Region'.

Verify Non-Unicode Settings

Click on the 'Administrative' tab and locate the 'Language for non-Unicode programs' section.

Match System Locales

Click 'Change system locale' and ensure the language matches the settings used on computers that do not experience the pasting issue, then restart the computer.

Check Regional and Language Encoding Settings

System Restart Required: Changing the system locale for non-Unicode programs will require a full PC reboot to take effect on the clipboard.

Solution 2

Verify Target Application Font and Character Support

The destination software might lack support for specific characters or fonts used in the original Excel form.

Free Microsoft Office alternative

Try WPS Office for Seamless Data Handling

If Microsoft Excel's clipboard formatting or macro execution continues to cause text encoding errors, WPS Office provides a lightweight, highly compatible alternative. It natively supports Microsoft Excel formats and ensures smooth data copying without unexpected character corruption.

1. Download and Install: Download WPS Office for free from the official website and install it on your device.
2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx or .xlsm workbook.
3. Copy and Paste Data: Select the required data or use your form buttons to copy the text, then paste it securely into your target application.

Fully compatible with Microsoft Excel (.xlsx, .xlsm, .csv) formatsRobust support for standard Unicode text and character encoding to prevent symbol errorsLightweight and fast, minimizing clipboard memory glitchesFree to use with a familiar spreadsheet interface for seamless migration

Frequently Asked Questions

Why does copied text turn into question marks when pasting from Excel?

This usually occurs due to character encoding mismatches between Excel and the target application, missing font support in the destination software, or the inclusion of unsupported characters like emojis in the source data.

How can I tell if my Excel copy macro is causing the symbol error?

You can isolate the issue by manually highlighting the text and pressing Ctrl+C to copy it. If manual pasting works perfectly but the macro button results in symbols, the VBA code handling the clipboard transfer likely requires an encoding adjustment.

Can regional settings affect how Excel copies text?

Yes. Windows uses regional and language settings to interpret non-Unicode characters. If the source computer and the destination computer have different locale configurations, the copied text may fail to translate properly through the clipboard.

Excel & Data Problems