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
Last edited by dahh; 07-01-2014 at 02:07 PM. Reason: Solved
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)),"")
Last edited by Bernie Deitrick; 07-01-2014 at 02:02 PM.
Bernie Deitrick
Excel MVP 2000-2010
Wow, thank you so much. It worked perfectly!
Thank you very much again Bernie for the update.
It appears both methods work!
Try
=PROPER(TRIM(MID(SUBSTITUTE(A2,"-",REPT(" ",LEN(A2))),LEN(A2),LEN(A2))))
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.
You're welcomeOriginally Posted by dahh
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"
I can't thank you enough.
I appreciate the quick learning experience!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks