Changing Text Using Formula

[dahh]

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

[Bernie Deitrick]

Change your formula to

=PROPER(Old formula without the equal sign)

To combine the formulas, use

=IFERROR(PROPER(LEFT(MID(A2,FIND("-",A2)+1,LEN(A2)),FIND("-",MID(A2,FIND("-",A2)+1,LEN(A2)))-1)),"")

[Jonmo1]

Try

=PROPER(TRIM(MID(SUBSTITUTE(A2,"-",REPT(" ",LEN(A2))),LEN(A2),LEN(A2))))

[dahh]

Wow, thank you so much. It worked perfectly!

[dahh]

Thank you so much Jonmo1!

Worked perfectly.
I think I understand most of the functions in your formula.
If I may ask what TRIM and REPT are?
Always trying to understand how a formula works rather than copy and paste it.

[dahh]

Thank you very much again Bernie for the update.
It appears both methods work!

[Jonmo1]

Thank you so much Jonmo1!

You're welcome

If I may ask what TRIM and REPT are?

Trim removes extra spaces.
Turns "____Hello____There___" into "Hello_There" <- _'s are spaces because forum software removes extra spaces..

Rept repeats a given string x number of times.
REPT("A",5) = "AAAAA"
REPT("hello",3) = "hellohellohello"

[dahh]

I can't thank you enough.
I appreciate the quick learning experience!