Changing a full number to a formatted number

%3CLINGO-SUB%20id%3D%22lingo-sub-3074386%22%20slang%3D%22en-US%22%3EChanging%20a%20full%20number%20to%20a%20formatted%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3074386%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20spreadsheets%20-%20one%20with%208%20digit%20numbers%20and%20one%20with%20***%20and%20then%20the%20remaining%205%20digits.%20I%20want%20to%20use%20a%20vlookup%20to%20combine%20them%20and%20this%20is%20the%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3074386%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

0 Replies