Dear DLL,
1. This works, except when the result-string = "".
2. I do not understand the formula, but why the "ISNUMBER"-function ? All
the characters are numbers.
Regards,
Gilbert

"daddylonglegs"
wrote in message
news:daddylonglegs.2bprpg_1154188208.0303@excelfor um-nospam.com...

If you need a solution which copes with different length numbers or
strings in A1 and B1, you could use this formula which utilises the
MCONCAT function from Morefunc add-in

=MCONCAT(IF(ISNUMBER(SEARCH(MID(A1,ROW(INDIRECT("1 :"&LEN(A1))),1),B1)),"",MID(A1,ROW(INDIRECT("1:"&L EN(A1))),1)))

confirmed with CTRL+SHIFT+ENTER


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=566278


--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
2591 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!