pasting data and loosing a digit

[kmc]

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?

 

[vlady]

try it like this.
Ctrl+H (find and replace)
Find: 8
Replace with: @8

then use the @ symbol for your delimeter.
use symbols that can't be found inside those alphanumeric strings