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 6906 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.

    36 comments

    • Comment Link Abgcfleet Wednesday, 31 March 2021 16:23 posted by Abgcfleet

      [url=https://thesiswritingtob.com/]writing my thesis[/url] thesis research proposal college thesis thesis paper writing

    • Comment Link RoAltet Saturday, 20 March 2021 05:55 posted by RoAltet

      Renovation of acrylic baths in Kolomna

    • Comment Link Vladimirgce Wednesday, 10 March 2021 00:53 posted by Vladimirgce

      удалите,пожалуйста! .

    • Comment Link KbbrSync Monday, 08 March 2021 01:58 posted by KbbrSync

      cialis vs viagra reddit canadian pharmacy cialis 20mg buy generic cialis

    • Comment Link NbmoSmert Wednesday, 03 March 2021 22:31 posted by NbmoSmert

      trial pack cialis viagra levitro http://buycialisxz.com/ cialis australia

    • Comment Link FjjuSmert Monday, 01 March 2021 22:16 posted by FjjuSmert

      herbal viagra reviews buy viagra connect viagra tumblr

    • Comment Link Vladimirlys Sunday, 28 February 2021 21:36 posted by Vladimirlys

      удалите,пожалуйста! .

    • Comment Link עיסוי אירוטי ברחובות Saturday, 20 February 2021 18:41 posted by עיסוי אירוטי ברחובות

      Hey, I think your site might be having browser compatibility issues.
      When I look at your website in Chrome, it looks fine
      but when opening in Internet Explorer, it has some overlapping.
      I just wanted to give you a quick heads up! Other then that, excellent blog!

    • Comment Link NbnhSmert Wednesday, 17 February 2021 11:00 posted by NbnhSmert

      where can i buy viagra online in india how much is sildenafil in uk viagra pharmacy cost

    • Comment Link Jbnvjorma Tuesday, 16 February 2021 19:44 posted by Jbnvjorma

      check cashing usa payday loans cash canada auto loans are online payday loans legal in wisconsin

    Leave a comment

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