Sorry, DDL, it works when the result-string is "", but it doen't work when
the A1-string is ""
Suggestions ?
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!