• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pasting values after using Text to Columns

D

DashboardNovice

Member
I used text to columns (delimited by a space), no problem. Then I copied some text from a PDF file and did paste/values. Instead of pasting into one cell, it is pasting values across cells wherever there is a space.

So it seems that Excel still thinks that I am using Text to Columns. How do I get rid of this?
 
You Can't
It isn't an issue with text to Columns
Thee issue is that the PDF has the data in columnar format and so even though it looks like a table it contains inbuilt columns which excel is happy to convert into columns on paste

You will need to allow for this in the spreadsheet
 
You must log in or register to reply here.
Back
Top