Link to home
Start Free TrialLog in
Avatar of Bill Golden
Bill GoldenFlag for United States of America

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
SOLUTION
Avatar of Serge Fournier
Serge Fournier
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bill Golden

ASKER

Serge, Your formula worked after I removed the E from TEXTE and replaced the ; with ,. Must have been some problem in the cut and paste. By the way, I've had plenty of sleep. Unfortunately still suffering from effect of Triple Chemo.

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!
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?