Excel Help #2

One more question, thanks again everyone for your help.

If I have 2 cells

AFL TRV


is there a way to turn these cells into
Afl Trv

Basically, how can I make the last 2 letters lowercase.

Once again. Thank you for all your help.

Tampa

 

=proper(text).

So if AFL is in A2, then do

=proper(a2)

 

To the rescue you again. Thanks much.

Tampa

Greatly Appreciated