Changing Text Using Formula

Hi Everyone,

I was wondering if there is a formula to change cell C2 to "Red" (One uppdercase, the rest lowercase) or if this was only possible through macro?
Also, would there be a way to combine B2 & C2? I apologize, but I am an amateur when it comes to formulas and that was the only logical way I could think of to get the output in C2.
B2 is actually not needed at all if possible. Thank you all in advance