proper formula - how to make the state be CAPS

K

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

JE McGimpsey

One way:

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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Anything will help 0
Formula to Separate City, State, Zip 6
Splitting rows into individual columns 2
Need help setting up weekly mail-merge format 1
alphabetize entire rows by first word of first column 5
Copy addition formula of non-consecutive horizontal cells 2
Macro using CLEAN & PROPER on a worksheet. 1

Top