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>
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
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>
 
Upvote 0
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:
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,937
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top