I know a way to do it but it's pretty much low-tech. I would copy the column
and paste it into Word. Edit - Select all - shift+F3 until I get all caps,
copy, and paste it back into Excel.

Sure.....go ahead and laugh at me and my silly ways. But it works. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]




"Robert11" wrote in message
...
Hello:

I have a long column with various text in the cells.
Both capital letters, and lower case. Some cells have both.

Would like to make everything CAPS in all the cells, hopefully in one
shot.

How can I do this, please ?

Thanks,
Bob