There is an Upper function

=Upper(A1)

Will take the contents of A1 and change it too upper case. You can then
paste it back special values only if that is necessary...
--
HTH...

Jim Thomlinson


"Hok Wong" wrote:

If I have an excel document where most of the text within the cells have been
written in lowercase, is there an easy way to change all the text into
uppercase? I thought i'd seen an option for that years ago, but typically,
now i want to use it, i can't find it.