How do you capitalize all letters?

Answer 1

You are not able to change case in place. You have to create a new Column or Row and use a formula to convert cells into all caps, all lowercase, or "proper".

=UPPER()

=LOWER()

=PROPER()

Then you can copy and paste the data from here. I hope this helps.

Answer 2

To capitalize all letters use the uppercase function with parenthesis and the word in double quotes as follows:

=UPPER("purity")

An example is shown below:

=UPPER("purity") is placed in cell A1