Generate SEO URL from String - Excel Formula



=LOWER(substitute(substitute((SUBSTITUTE (SUBSTITUTE(SUBSTITUTE(SUBSTITUTE (SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE (SUBSTITUTE(SUBSTITUTE(SUBSTITUTE (TRIM(SUBSTITUTE(SUBSTITUTE( SUBSTITUTE(B3,"'","")," - ","-")," / ","-") ),"/",""),"+",""),"®",""),"™",""),":",""),")",""),"(","" ),"&",""),".",""),"""",""),",",""))," ","-")," & ","")

Popular posts from this blog

[Solved] Hive installation error: java.net.URISyntaxException: Relative path in absolute URI

Install Android SDK in centOs

Installing arules package (Association Rules) in R