Max wrote:
||| What does TRIM do that just "=UPPER(A1)" doesn't?
||
|| It isn't relevant here as far as changing the case goes, but I'd
|| normally use TRIM as well whenever working on text cols, to tidy
|| up/remove any extraneous spaces which might be present. The result?
|| A cleaner output besides the case conversion. Just a die-hard habit,
|| I guess <g. --
|| Rgds
|| Max

Good thinking.......

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk