On Thu, 31 Jan 2008 12:50:12 -0500, "T. Valko" wrote:

If it is less than eight, you can nest SUBSTITUTE functions.

If you're using Excel 2007 you can nest up to 64 levels plus the top level =
65.

One of these days I'm going to try that out just to see what it looks like!

--
Biff
Microsoft Excel MVP

I can't imagine not using VBA if I had something that complex.
--ron