'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Stop Excel from Adding Double Quotes When Copying Text
Question details
The user is experiencing an issue where copying text from an Excel cell range automatically wraps the copied text in double quotation marks.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Copying cell data from a workbook to paste into another application, text file, or location.
- Observed behavior
- Excel automatically adds double quotation marks around the copied text due to inherited text-formatting settings or hidden characters in the source file.
Check your original data to see if it contains hidden line breaks (Alt+Enter) or commas, as these automatically force Excel to add quotation marks when copying to external applications.
Use Paste Special to Copy Values Only
Bypass the underlying cell formatting that triggers quotation marks by pasting only the raw data values.
When you copy data normally, Excel brings along the cell's text-formatting settings, which can sometimes translate into added quotation marks when pasting. Using the Paste Special feature strips this hidden formatting.
Highlight the required cell range in your spreadsheet and press Ctrl+C to copy.
Right-click on the destination cell where you want to paste the data.
Select 'Paste Special' from the context menu, then choose 'Values' (the clipboard icon with '123'). This pastes the raw text without the problematic formatting.
Clear Text Formatting in the Source Cells
Remove hidden text formatting attributes from the original Excel file to prevent quotes from being added during the copy process.
Remove Line Breaks Using the CLEAN Function
Hidden characters and line breaks force Excel to wrap text in quotes. The CLEAN function removes these non-printable characters.
Use WPS Spreadsheet to Avoid Formatting Errors
WPS Spreadsheet provides a highly intuitive Paste Special feature and robust formatting tools, making it easy to copy raw data without accidentally carrying over hidden characters or unwanted double quotation marks.
- 1. Open your file in WPS Office: Launch WPS Spreadsheet and open your existing Excel workbook.
- 2. Copy the required data: Highlight the cells you need and press Ctrl+C.
- 3. Use Paste Special: Right-click your destination, hover over 'Paste Special', and select 'Values' to paste clean, quote-free text.
Frequently Asked Questions
Why does Excel add quotation marks when copying to Notepad?
Excel automatically adds double quotes around copied text if the cell contains commas, double quotes, or line breaks (carriage returns). This is Excel's way of ensuring the data remains grouped as a single entity when pasted into plain text editors or saved as CSV.
How do I stop Excel from adding quotes when saving as CSV?
To prevent quotes in a CSV file, ensure your data does not contain commas or line breaks. You can use the Find and Replace tool (Ctrl+H) to replace commas with spaces, and replace line breaks (Ctrl+J) with nothing, before saving the file.
Will clearing cell formatting delete my data?
No. Selecting 'Clear Formats' from the Home tab only removes visual styles (like bold text, colors, or custom number formatting) and resets the cell to the default 'General' format. Your raw text or numbers will remain perfectly intact.
