On Mon, 19 Nov 2007 11:42:15 -0800 (PST), Pete_UK wrote:


For more than that, you can use VBA routines.
--ron

Well, you could continue into another column, Ron.

Pete

You could, but that would not satisfy the OP's request of "all in one formula".


--ron