Thread: Eliminate the need for Nested Substitute

Hi,

Assume A1: ABCDABCDABCD

If I want to delete all "A"s and "D"s I would use: =SUBSTITUTE(SUBSTITUTE(A1,"A",""),"C","")

and get: BDBDBD which is fine

My question:

Is there a way to use SUBSTITUTE only once ?

Something like: =SUBSTITUTE(A1,{"A";"C"},"")

I tried it, with no success.

All I'm looking for is a WS build-in function.

Thanks, Elm

No; array-entered, the second function returns two results, one deleting As and one deleting Cs. You need the results of one invocation returned to the second.

Just reiterating shg's point - no, not really, nothing practical at any rate.

I asked a similar question at MrExcel.com sometime back which may/may not be of interest - you might like PGC01's response however (post #19)

http://www.mrexcel.com/forum/showthread.php?t=332284