proper formula - how to make the state be CAPS

[kmjmail]

In my worksheet I have the address in separate columns, when I put in a
Proper formula to get the Address City, ST and zip to be all in one cell the
State is always Oh instead of OH and Mi instead of MI. Is there a way to get
the state to be CAPS?

Thanks for you help.

 

[JE McGimpsey]

One way:

B1: Address
C1: City
D1: State
E1: Zip

G1: =PROPER(B1 & ", " & C1) & ", " & UPPER(D1) & " " & E1

 

[Sheeloo]

What is the formula you are using?

If you have lower case text in A1 then
=UPPER(A1) in any other cell will convert it to Upper case.