excel 2010: text to columns is remember, how to get rid of this?

excel text excel-2010 multiple-columns pasting
DutchArjo picture DutchArjo · Mar 17, 2016 · Viewed 15.5k times · Source

I have tekst copied from a pdf file to Eexcel(2010). I used 'text-to-columns' to create separate columns.

Now I have finished that part of my task, I want to paste another piece of text into the same file.

But now Excel directly uses the text-to-columns I used to split this new text, which I now (obvious) do not want to be split. I tried pasting the text on a new worksheet. I tried to paste this text in a new workbook, but still the text is directly split by excel.

I tried pasting as text and I tried pasting as unicode text. But so far, I have not found the solution for this. How can I make Excel "forget" that it has split text into columns?

Answer

user4039065 picture user4039065 · Mar 17, 2016

Select any cell with a value and run Data ► Text-to-Columns, Delimited. Turn off all delimiters and click Finish.

    Text-to-Columns delimited, none

Subsequent pasting of information into a worksheet will not use 'remembered' delimiters since there are none.

Related questions

Insert characters into string in different locations

I have a string which looks like this 20141007023617. And I would like to make it look like this 2014-10-07T02:36:17Z. The T and Z are very important for me. So I would like to insert them as well. …

Read More
How do I Replace a String in a Line of a Text File Using FileSystemObject in VBA?

I am trying to use FileSystemObject methods to find a specific line in a text file, and within that line replace a specific string. I am relatively new to this, as my current code has excel open the text file …

Read More
Python Throwing "'utf8' codec can't decode byte 0xd0 in position 0" Error

I am trying to load a currently existing worksheet and import the text file (comma separated values) screenshot shown below, Excel Sheet: Text File: I am using the code shown below: # importing necessary modules for performing the required operation import …

Read More