Convert string to upper case

=upper(A2)
The excel formula above will convert text of any format to capital letters. For instance, if the text in cell a2 said "trust", then the formula will convert it to "TRUST".

Read More..