Replacing wrong data
I imported a custoemr list into Excel from a DB. Everything imported ok
except for the telephone number. The last digit was dropped. I have a second
workbook with the correct phone numbers. I would like to do a match of the
phone numbers and either add the lost digit back or replace the entire phone
number. Ever thiing I have tried returns a #Value eror. The phone format is
(###) ###-####.
|