Multiple Formulas in one Cell

sushantsawant

New Member
Joined
Oct 8, 2014
Messages
3
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>
 

Some videos you may like

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

sushantsawant

New Member
Joined
Oct 8, 2014
Messages
3
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
Joined
Jul 14, 2014
Messages
1,678
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:

Watch MrExcel Video

Forum statistics

Threads
1,108,787
Messages
5,524,877
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top