- Insert the text you wish to manipulate in the first cell. In our example, I named my first column "Title"
- 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.