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))
Copy down

Copy col B and then right click on col A
Choose paste special values OK to overwrite col A

Delete col B
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Winsome" wrote in message
...
When there is a column of text how do I change the text in the whole
column
to UPPERCASE in one step?