# Multiple Formulas in one Cell

#### sushantsawant

##### New Member
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:
 "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

<tbody>
</tbody>

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### NeonRedSharpie

##### Well-known Member
Yes. There is.

Code:
``=LOWER(SUBSTITUTE(A1," ","-"))``

#### sushantsawant

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

The text is:
 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

<colgroup><col width="309"></colgroup><tbody>
</tbody>

#### NeonRedSharpie

##### Well-known Member
Code:
``=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.
Code:
``=LEFT(LOWER(SUBSTITUTE(A1," ","-")),FIND("|",A1)-2)``

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

Code:
``=SUBSTITUTE(LOWER(SUBSTITUTE(A1," ","-")),"-|-lupo","")``

Last edited:

#### sushantsawant

##### New Member
Awesome man. You're a Rockstar!!

Replies
5
Views
110
Replies
0
Views
110
Replies
15
Views
344
Replies
13
Views
185
Replies
1
Views
95