Combine 3 forumlas

[giftguys]

Does anyone know if i can combine these 3 into 1? Having trouble figuring it out.

=LOWER(CONCATENATE("/",C2,".html"))
=SUBSTITUTE(c2," ","- ")

 

[dreid1011]

The only thing I could even guess without seeing your data before and after the formula, is to try this:

=LOWER(CONCATENATE("/",SUBSTITUTE(c2," ","- ") ,".html"))

or

=SUBSTITUTE(LOWER(CONCATENATE("/",C2,".html"))," ","- ")

If you could provide a sample piece before you run the formulas on it, and the expected results, then I could help further if this is not correct.

 

[giftguys]

The first formula you listed worked perfect. I just couldn't figure out the right combination. Thanks!!

 

[dreid1011]

You're welcome, glad one of those worked for you.