Sample/example:

with your short tele's starting in A2;
then enter into B2
=TEXT(INDEX(B!$A$3:$A$8,MATCH(A!A2,LEFT(B!$A$3:$A$ 8,9),0),1),"(###)-###-####") <<This is a Control Array Formula - DOnot press enter, Rather
Press Control+Shift+Enter Simultaneously

Afterwards B2 will look like:
{=TEXT(INDEX(B!$A$3:$A$8,MATCH(A!A2,LEFT(B!$A$3:$A $8,9),0),1),"(###)-###-####")} You cannot enter the { }'s manually -

Copy this formula down
The B!$A$3:$A$8 refers to your New Tele's set out in range A3 to A8 on
Sheet B
HTH

Jim May


"Wayne" wrote:

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
(###) ###-####.