I'd simply get it done in an adjacent col
In B2: =TRIM(UPPER(A2))
B2 copied down as far as data is expected in col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Carin" wrote:
I need to format cells in Excel so it automatically converts text to all CAPS
when a user enters in data.