Max wrote:
|| If you're not too particular about an extra 2-3 steps ..
||
|| Assume col A is the col of text in A1 down
||
|| Put in B1: =TRIM(UPPER(A1))

What does TRIM do that just "=UPPER(A1)" doesn't?
--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk