"Gilbert De Ceulaer" skrev i en meddelelse
...
In one cell I have the string "2367"; in another I have "26".
I want to have "37" as a result.
How do I do it, "NAND" not being an available function ?
Thanks,
Gilbert




Hi Gilbert

Here's an array formula. A1 and B1 can hold numbers as text or number,
but not enclosed in double quotes.

=SUBSTITUTE(SUM(ISERROR(SEARCH(MID(A1,ROW(INDIRECT ("1:"&LEN(A1))),1),B1))*
10^(LEN(A1)-ROW(INDIRECT("1:"&LEN(A1))))*MID(A1,ROW(INDIRECT(" 1:"&LEN(A1))),1)),0,"")

to be entered with <Shift<Ctrl<Enter instead of <Enter.

--
Best regards
Leo Heuser

Followup to newsgroup only please.