It could take 3 minutes to use Anne's macro on 600kHz machine if one
chose the entire column. Speed would be greatly improved by
even limiting to the used range. SpecialCells is automatically
limited to the usedrange by definition, but by limiting the cells
processed to TEXT you have even fewer cells to process.
See
http://www.mvps.org/dmcritchie/excel/proper.htm#upper
I avoid using value so even if someone messes with the procedure
they are still less likely to do damage by using formula rather than
value.
With MS Word your selection would be much smaller but with
Excel processing 65536 cells per column whether you need
to process them or not can take a long time.
In any case a macro solution is best, because you will
process the cells once, in place, and be done with it. There are so
many gyrations involved with using a Worksheet Formula
and then changing the content of the original or replacement
column with capitals that even outside the programming group
I wouldn't really recommend the worksheet solution.