Many thanks for the responses. I've used a combination: "upper" to
convert all the existing entries and Bob's magic formula to ensure that
it stays looking tidy. (Bob - thanks. I have not the faintest idea how
that works but it does.)

Trevor


--
Trevor Coultart
------------------------------------------------------------------------
Trevor Coultart's Profile: http://www.excelforum.com/member.php...o&userid=24945
View this thread: http://www.excelforum.com/showthread...hreadid=384807