Excel Help #2

T

tampatrader82

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
 
Quote from tampatrader82:

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

=proper(text).

So if AFL is in A2, then do

=proper(a2)
 
You must log in or register to reply here.
Back
Top