=UPPER(text)
Where (text) is the cell you want to change

"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.