Hello, I am pasting a list of text and numbers (1 col each) from a website to notepad then into an existing sheet, (done this many times and it works well to remove website formatting stuff).
However, this time I am loosing the numeral "8" in the list of numbers. On a previous copy and paste of the same type, I had to run a text to columns using the number 8 as the delimiter to separate the text from the numbers. Then used =CONCATENATE adding the number "8" back to the column of numbers. In this copy and paste I do not need to do that, however when I paste, it is as if the Text to columns ran and I loose the numeral 8.
I have tried pasting into a new sheet, a new tab, and closing original doc, then opening back up and pasting in. Still loosing "8"
"Paste as" only give text or Unicode options.
Any thoughts?
However, this time I am loosing the numeral "8" in the list of numbers. On a previous copy and paste of the same type, I had to run a text to columns using the number 8 as the delimiter to separate the text from the numbers. Then used =CONCATENATE adding the number "8" back to the column of numbers. In this copy and paste I do not need to do that, however when I paste, it is as if the Text to columns ran and I loose the numeral 8.
I have tried pasting into a new sheet, a new tab, and closing original doc, then opening back up and pasting in. Still loosing "8"
"Paste as" only give text or Unicode options.
Any thoughts?