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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |