Data Import & Export

How to Fix Excel Copy and Paste Splitting Data into Multiple Columns

Aamir Naveed Akram Oct 22, 2026 868 views

Question details

Users need to stop Excel from automatically separating pasted text into different columns instead of keeping it in a single column.

Product: Excel
Device & OS: not provided
Scenario: Copying text or delimited data from an external source or another worksheet and pasting it into an Excel spreadsheet.
Observed behavior: Excel automatically splits the pasted content across multiple columns because it retains the delimiter settings from a previous Text to Columns operation.

Before you start

Before proceeding, check if you or someone else recently used the 'Text to Columns' tool in your current Excel session, as Excel temporarily saves these delimiter settings.

Solution 1Recommended

Reset the Text to Columns Delimiter Settings

Clear the active delimiter options in the Text to Columns wizard to force Excel to paste data as normal text.

Excel is designed to remember the settings from your most recent Text to Columns action. If you previously split data using commas, spaces, or tabs, Excel applies those same rules to anything new you paste. By clearing these settings, you restore the default paste behavior.

Select an empty column

Click on any empty cell or select a single blank column in your current Excel worksheet.

Open the Text to Columns wizard

Navigate to the 'Data' tab on the Excel ribbon and click on 'Text to Columns' in the Data Tools group.

Choose Delimited data type

In step 1 of the wizard, ensure that 'Delimited' is selected, then click 'Next'.

Clear all delimiters

In step 2, uncheck all the boxes under the Delimiters section (such as Tab, Semicolon, Comma, Space, and Other). Ensure no options are selected.

Finish the wizard

Click the 'Finish' button. You do not need to proceed to the third step.

Paste your data again

Copy your original text and try pasting it into your desired cell. It should now remain in a single column.

Reset the Text to Columns Delimiter Settings

Settings Successfully Cleared: Excel will now treat your pasted data as standard text. You will need to reconfigure these settings the next time you actually want to split text.

Free Microsoft Office alternative

Switch to WPS Office for a Smoother Spreadsheet Experience

If persistent formatting quirks in Microsoft Excel are slowing down your workflow, consider trying WPS Office. It provides a highly compatible, lightweight, and user-friendly spreadsheet tool that makes copying, pasting, and managing data completely effortless.

1. Download WPS Office: Visit the official WPS website to download the free office suite installer for your operating system.
2. Install and Launch: Follow the quick installation prompts, then open the WPS Spreadsheet application.
3. Open Your Workbooks: Open your existing Excel files and seamlessly continue your work with zero learning curve.

100% free to download and use with a clean, familiar interface.Seamless and full compatibility with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight architecture ensures fast performance without lagging.Smart paste options to give you exact control over your data layout.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel remember my Text to Columns settings?

Excel caches your Text to Columns delimiter settings during an active session to save you time if you need to process multiple batches of similarly formatted data. However, this causes unintended splitting when you paste plain text later.

Does closing and reopening Excel fix the paste issue?

Yes, completely closing all Excel windows and restarting the application clears the temporary Text to Columns cache, restoring the default single-column paste behavior.

Can I permanently disable Excel's automatic splitting feature?

No, there is no setting to permanently turn off this behavior. You must either restart Excel or manually clear the checkboxes in the Text to Columns wizard whenever the issue occurs.

How can I bypass the splitting without changing settings?

You can try double-clicking the cell to enter 'Edit Mode' (or press F2) and then paste your data directly into the formula bar or the cell. This forces Excel to treat the pasted content as a single text string.

Excel & Data Problems