How do I paste data into multiple columns in Excel?Īfter selecting the range of cells press Ctrl + C together to copy the range of cells. That will give you the character Ò, which you can copy from your formula bar and paste to the wizard as your delimiter.READ: Is a 250 2 stroke too much for a beginner? Select an empty cell hold down your Alt key then in your keyboard’s ten-key pad, type: 01234. Or, if that’s not obscure enough for you, you can use a Unicode character. I’ve found two ways to do it.įirst, you can go back into the Text to Columns Wizard and change the setting to use an obscure delimiter, like the character. This is because, once you’re done splitting text into columns, you need to be able to turn off that feature. But How Do You STOP Changing Text to Columns?!!! Also, this method does not split columns if you choose Fixed Width instead of Delimited. It works when you copy text, but not if you copy another cell.

This method works with every delimiter I’ve ever tried, and with every recent version of Excel through Excel 2010. Instead, it used each space in the table’s text as a delimiter and pasted the table into separate columns, just as I had specified using the initial Text to Columns command. That is, Excel didn’t paste the table into column A this time. When I pasted the next table, Excel automatically applied my current text-to-columns setting to the new data. If you work with text files much, you probably know all about this command. Then, in the Wizard, I chose Delimited, specified Space as the delimiter, and then chose OK. I just selected the column of data and then, in my Ribbon’s Data, Data Tools group, I chose Text to Columns. When I pasted the first table, all the data was pasted into column A, with a space between each number. Today I needed to copy a bunch of numeric tables from a pdf file into Excel.

How to paste list into excel cells