Bill Golden
asked on
Combining Multiple Text Strings in a Single Cell
C2=12/31/16
C3=and
C4=12/31/16
=PROPER(TEXT($C$2,"MMMM D, YYYY")&" and "&TEXT($C$4,"MMMM D, YYYY"))
Returns
December 31, 2016 And December 31, 2015 (I DO NOT want to capitalize the "a" in the separator "and")
So, it tried it another was
=PROPER(TEXT($C$2,"MMMM D, YYYY")&" "&LOWER($C$3)&" "&PROPER(TEXT($C$4,"MMMM D, YYYY")))
Which Returns
December 31, 2016 And December 31, 2015 (The exact same thing!)
What am I missing here? Sample snippet file is attached
EE-Beginning-and-Ending-Date.xlsx
C3=and
C4=12/31/16
=PROPER(TEXT($C$2,"MMMM D, YYYY")&" and "&TEXT($C$4,"MMMM D, YYYY"))
Returns
December 31, 2016 And December 31, 2015 (I DO NOT want to capitalize the "a" in the separator "and")
So, it tried it another was
=PROPER(TEXT($C$2,"MMMM D, YYYY")&" "&LOWER($C$3)&" "&PROPER(TEXT($C$4,"MMMM D, YYYY")))
Which Returns
December 31, 2016 And December 31, 2015 (The exact same thing!)
What am I missing here? Sample snippet file is attached
EE-Beginning-and-Ending-Date.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Subodh, your formula worked but preferred a formula which preferred the Proper designation.
"mmmm" or "MMMM" will always return month names in proper case. What's the use of Proper function then in your formula?
ASKER
Subodh, your formula worked but preferred a formula which preferred the Proper designation.
gowflow, that was your solution. Next question is the same situation, with a tougher required outcome, I think!