Formula that Transforms Cell Column into Lower Case and replaces spaces with hyphens

[diemking]

Hopefully the title was descriptive enough but is there any cell input I could do that does that? Here's an example of what I am looking for:

Column K | Column L

(Winning Name) | (Final Slug)
APRICOT PEET | apricot-peet
d'''':,/whickey: | dwhickey
FOR EVER defi | for-ever-defi
hungry-hippos | hungry-hippos

-where Winning Name is Column K and Final Slug is Column L
-APRICOT PEET is Cell K3
-final slug contains winning name except:
---all lower case
---spaces and hyphens converted into hyphens
---all other punctuation (commas, apostrophes, colons) removed

I know this is a pretty complex formula but is there any way I can figure this out with an excel formula?

Thank you so much!

[FDibbins]

Hi and welcome to the forum

Try this in a column L, copied down...
=LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(K3,",",""),":",""),"'","")," ","-"))

[diemking]

Thank you so much FDibbins! The code worked perfectly
The more I use excel, the more I'm amazed at the formula possibilities