On Thu, 12 Nov 2009 18:02:57 -0800 (PST), Pete_UK wrote:

Thanks for that, Ron.

And your formula was more elegant than mine, too. <bg

Pete

Thank you, Pete.

I vacillate between using numeric vs text-based approaches to problems like
this. But with text-based approaches, I don't really have to worry about
rounding issues. And I also like the MID function ever since I figured out
that it didn't care if the number of characters took you past the end of the
word.
--ron