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