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

What are EAR, JAR and WAR files in J2EE?

ATG Issue - ConcurrentUpdateException - on BCC Deployment

How the competition helps to reduce the price of TEA?