LATEST >>

Welcome Here And Thanks For Visiting. Like Us On Facebook...

EXEIdeas – Let's Your Mind Rock » PC / PC Tips » Convert Any String To Slugify Using Excel Function For Bulk URL Creation

Convert Any String To Slugify Using Excel Function For Bulk URL Creation

Convert-Any-String-To-Slugify-Using-Excel-Function-For-Bulk-URL-Creation
“Slugify” is a term for converting strings into URL slug format. A URL slug, or just slug in this article’s context, is the part of the URL that comes after the domain extension. In this guide, we’re going to show you how to slugify a string with Excel.

Periodically I run into the issue where I need to create a lot (thousands) of URLs from random strings of text, which may or may not include capital letters, spaces, hyphens, brackets, commas, etc.

Sometimes this is easiest done in a spreadsheet, so here’s an Excel function I baked up a couple of years ago that I use to solve the particular problem of slugifying/handling those URLs. It’s clunky, but functional*. Just replace “A2” with whatever cell you need to slugify, and voila.

*Only works for ASCII characters. Does not check for collisions!

Features:

  1. Light Weight.
  2. Pure Excel Function.
  3. No External AddsOn.
  4. Work With Any Format Of Text.
  5. Fully Customizable.

Slugify Examples:

Web Page TitleSEO-friendly URL Slug
AS dsf a s1111#$ b’lue p”urple AsdoIjas-dsf-a-s1111-blue-purple-asdoij
Elon Musk considers move to Marselon-musk-considers-move-to-mars
Fintech startups raised $34B in 2019fintech-startups-raised-dollar34b-in-2019
Shopify joins Facebook’s cryptocurrency Libra Associationshopify-joins-facebooks-cryptocurrency-libra-association
What is a slug and how to optimize it?what-is-a-slug-and-how-to-optimize-it
Bitcoin soars past $33,000, its highest everbitcoin-soars-past-dollar33000-its-highest-ever
Recommended For You:
Perfect Toner Or Cartridges For Home Office Printers

Excel Function:

=LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(A2)," ","-"),"'",""),"""",""),"/",""),"?",""),".",""),">",""),"<",""),",",""),";",""),":",""),"[",""),"]",""),"}",""),"[",""),"{",""),"|",""),"\",""),"+",""),"=",""),"~",""),"`",""),"!",""),"@",""),"#",""),"$",""),"%",""),"^",""),"&",""),"*",""),"(",""),")",""),"#",""),"'",""),"""",""),"---","-"),"--","-"))

Customization:

No need to customize it. Just copy-paste. Rest edit the code as per comments and need.

Troubleshooting the Errors:

Do it with concentration and patience. Check your all steps again and all codes or scripts. If you find any error you can contact us anytime via comment or better via email, We are always here to help you.

Final Words:

That’s all we have. We hope that you liked this article. If you have any problem with this code in your template then feel free to contact us with a full explanation of your problem. We will reply to you as time allows us If you have any doubts or problems please comment below. We are happy to help you! If you liked this article, Don’t forget to share this with your friends so they can also take benefit from it, and leave your precious feedback in our comment form below. Happy development, See you in the next article.

You Like It, Please Share This Recipe With Your Friends Using...

Be the first to write a comment.

Leave a Reply

Your email address will not be published. Required fields are marked *