Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MATCH AND REPLACE TEXT FROM TWO DIFFERENCE WORKBOOKS
I imported data from a DB to an Excel spreadsheet "A". The import left out
the last digit of the phone number. The spreadsheet has been modified and sorted to meet each users needs. When the error was discovered I re-imported the data "B" and the complete phone number appeared in (###) ###-#### format. I would like to match the phone number in SS "A" with that of SS "B" and replace the phone number in SS "A" with the correct one from SS "B". I tried nesting the replace and match formulas, the fnd formula and others but always get a "#value" error. Thanks in advance Wayne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MATCH AND REPLACE TEXT FROM TWO DIFFERENCE WORKBOOKS
Wayne wrote:
I imported data from a DB to an Excel spreadsheet "A". The import left out the last digit of the phone number. The spreadsheet has been modified and sorted to meet each users needs. When the error was discovered I re-imported the data "B" and the complete phone number appeared in (###) ###-#### format. I would like to match the phone number in SS "A" with that of SS "B" and replace the phone number in SS "A" with the correct one from SS "B". I tried nesting the replace and match formulas, the fnd formula and others but always get a "#value" error. Thanks in advance Wayne Hi Wayne, I think you can use a VLOOKUP. Check the online help and try. If you need more help we are here... -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to replace "#N/A" w "0"when vlookup couldn't find the match? | Excel Discussion (Misc queries) | |||
Match and replace cells between two worksheets | Excel Discussion (Misc queries) | |||
Can I match the beginning of text in an Excel cell? | Excel Discussion (Misc queries) | |||
Look up/math text | Excel Worksheet Functions |