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 (###) ###-####. |
Replacing wrong data
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 (###) ###-####. |
All times are GMT +1. The time now is 07:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com