Put in say, B1: =UPPER(A1)
Copy down
Copy col B and paste special as Values to overwrite col A
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"smithrdsr" wrote in message
...
How to change data by column or comlete spreadsheet from lower case to
upper
case by column.