Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 (###) ###-####. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 (###) ###-####. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |