Convert terms into url names in google sheets-CodePudding

Home > Software engineering > Convert terms into url names in google sheets

Convert terms into url names in google sheets

Time：07-07

let's suppose I had a column A in google sheets holding terms like

that I would like to convert to url names like

So basically trying to make the word "url" friendly. Is this something that is possible in google sheets?

CodePudding user response：

Give a try on-

=REGEXREPLACE(REGEXREPLACE(A1, "[^a-zA-Z0-9\-\s]", ""),"[ ]","-")