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
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Gordon" wrote in message
...
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