Multiple Formulas in one Cell

[sushantsawant]

Hello Everyone,

Is there a way to apply multiple formula in one single cell?

I need to apply 2 formula in one cell "LOWER" & "SUBSTITUTE".
For instance:
This tex: [TABLE="width: 309"]
<tbody>[TR]
[TD="width: 309"]"Lupo Heel N Toe Yoga Barre Pilates Socks"

Should be:
"lupo-heel-n-toe-yoga-barre-pilates-socks"

Any suggestions would be appreciated.

Thanks,
Sushant
[/TD]
[/TR]
</tbody>[/TABLE]

 

[NeonRedSharpie]

Yes. There is.

=LOWER(SUBSTITUTE(A1," ","-"))

 

[sushantsawant]

Thanks Mate. Just one more query. Can we use "Substitute" function twice in the same formula.

The text is:
[TABLE="width: 309"]
<colgroup><col width="309"></colgroup><tbody>[TR]
[TD="width: 309"]Heel N Toe Yoga Barre Pilates Socks | Lupo

Need it to be:
heel-n-toe-yoga-barre-pilates-socks

The end part " | Lupo" needs to be removed.

Thanks,
Sushant
[/TD]
[/TR]
</tbody>[/TABLE]

 

[NeonRedSharpie]

=SUBSTITUTE(LOWER(SUBSTITUTE(A1," ","-")),"|","-")

You can nest it as far as your heart's content.

Hold please...you said removed....wait for it...

See below.

=LEFT(LOWER(SUBSTITUTE(A1," ","-")),FIND("|",A1)-2)

Unless it's ALWAYS " | Lupo" in which case:

=SUBSTITUTE(LOWER(SUBSTITUTE(A1," ","-")),"-|-lupo","")

 

[sushantsawant]

Awesome man. You're a Rockstar!!