proper formula - how to make the state be CAPS
 

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.

proper formula - how to make the state be CAPS
 

One way:

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

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



In article ,
kmjmail wrote:

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.

proper formula - how to make the state be CAPS
 

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.



"kmjmail" wrote:

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.

proper formula - how to make the state be CAPS
 

Thank you so much, it worked perfectly.

"JE McGimpsey" wrote:

One way:

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

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



In article ,
kmjmail wrote:

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.