Thursday, 11 February 2016 19:02

    How to change a text to lower case and replace space with a dash in Excel

    Written by
    Rate this item
    (1 Vote)
    How to change a text to lower case and replace space with a dash in Excel

    In this article, you will learn the formula to change text to lower case and replace space by a dash.

    This can be useful when importing CSV file to a CMS like Joomla where articles titles need their respective aliases to be in lower case.

    • Insert the text you wish to manipulate in the first cell. In our example, I named my first column "Title"

      Lowercase and substitution tutorial pic2

      •  

       

    • Select the adjacent cell (B2) and type the following formula in the second or third cell of your Exel sheet:

      =LOWER(SUBSTITUTE(A2," ","-"))

      The LOWER function change the text to lower case and the SUBSTITUTE function change the space to a dash. You may of course change it to any character of your choice. Copy down and you are done.

      Lowercase and substitution tutorial pic1

      •  

       

     

     

     

     

    Read 3506 times Last modified on Thursday, 11 February 2016 19:24
    Published in Microsoft Excel
    Tagged under
    Fabien Bello

    Fabien Bello has been working in web and app develoment since 1997. He has held numerous positions from game developer to head of creative and product development for major firms such as Xerox, Gala Coral Group. Fabien continues contributing to online community, owns and manages several websites as well as offering consultancy to all size businesses.

    Latest from Fabien Bello

    Related items

    More in this category: « How to convert CSV date format into MySQL date format in Excel How to convert a 10 Digit Number (or Unix Timestamp) into a date in excell »

    Leave a comment

    Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

    back to top