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)

    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 7465 times Last modified on Thursday, 11 February 2016 19:24
    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.


    Leave a comment

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