Changing a full number to a formatted number

[cholt1811]

I have two spreadsheets - one with 8 digit numbers and one with *** and then the remaining 5 digits. I want to use a vlookup to combine them and this is the