Forum Discussion
Solved
Help combining multiple formulas
Hi there, If someone could tell me how to combine all these formulas I would REALLY appreciate it. =CONCATENATE(LEFT(A2,1),B2) =LOWER(E2) =SUBSTITUTE(H2," ","") =SUBSTITUTE(H2,"-","") =SU...
It takes less than a second.
=LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(LEFT(A1)&B1),"-","")," ",""),".",""),8)
It takes less than a second.
=LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(LEFT(A1)&B1),"-","")," ",""),".",""),8)
Detlef_Lewin Thank you so much!!!! I'm sure you're not surprised that it works perfectly. And now that i've seen it done, it makes a lot more sense to me.
I'd change the order a bit - first to clean, or at least trim, A1 and B1 separately and finally combine first character from former A1 and entire B1.
