I've got a vlookup challenge that I'm not sure how to overcome. I must
manually click on the source cell which is a seven digit number and move the
cursor to the right of the number (XXXXXXX)|(Click Delete) then the vlookup
will work.

I've tried to copy and paste values only. I've tried to use the Left or
Right command to just bring over the 7 characters and trim. There appers to
be something to the right that needs to be moved or deleted.

Any ideas? Thanks,

--
Credit Law Guy