| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change from all caps to proper case? | Excel Discussion (Misc queries) | |||
| Is there a way to change Lowercase or Proper to ALL CAPS? | Excel Worksheet Functions | |||
| Converting All Caps to Proper casing | Excel Worksheet Functions | |||
| How do I make some columns all caps and others proper? | Excel Discussion (Misc queries) | |||
| How do I change a spreadsheet from all caps to "Proper" | Excel Discussion (Misc queries) | |||
Linear Mode
