How to convert text to dash-case in Google Sheets

So let us start with explaining which tools we are going to use. Since this tutorial is focused on Google Sheets I assume you have a Google account with access to Google sheets. You can simply create a Google Drive account and should be set up then. Then simply create a new Google Spreadsheet.

Now we have to fill the spread sheet with data. For that we can use several data sources. Ideally you should use your own or even have data in your spreadsheet already. For an easy way to follow this tutorial simply copy the following list items and insert them into the spreadsheet:

• case converter extension
• case converter near me
• case converter chrome extension
• case converter transformation in informatica
• case converter in excel
• case converter textmagic
• case converter download
• case converter html
• case converter visual studio
• title case converter
• upper case converter
• camel case converter
• title case converter online
• snake case converter
• alternating case converter
• kebab case converter
• pascal case converter
• camel case to snake case converter
• random case converter
• cassette converter
• case sensitive converter
• cassette to mp3 converter
• case 450 dozer torque converter
• cassette tape converter
• casey horner catalytic converter
• case 580k torque converter
• cassette to digital converter
• case sentence converter
• case title converter

So now we can actually work on the data. Now we will work on column B. Google Sheets supports the LOWER() and UPPER() functionality. These work kind of similar to what we want to achieve. Just that there need to be a function called DASH_CASE().

For this use case we need to extend Google Sheets though. This requires some programming but do not fear back. This article is written for everyone, even if you do not have any programming experience. Google supports something called the Script editor which we will open now. For that, go to the menu bar, click on Tools and then on Script Editor.

This should open a new tab. Do not scare back yet! The first thing you should do is to delete all the code in the script section so it looks like the following:

Now its time to code! Or as we say, just copy paste some snippets we have prepared for you. You can copy and paste the following code into the script window.

The script window should look like the following then:

Now it is time to press the save icon on top of the code. Alternatively you can press CTRL + S (CMD + S on Mac) to save the script and then we can head back to the Google Sheet. Reload the page once. Ideally with CTRL + R (CMD + R on Mac). And select the field B1.

As with the LOWER() function we can use the DASH_CASE() function now. Simply type the following into the field B1: =DASH_CASE(A1)

And this results in the following value of the column: case-converter-extension. So now we can also apply the function to all rows. You can do that by simply dragging the bottom right corner of field B1 to the bottom. You can also see it in the GIF below.

So this should have brought you to your goal. Feel free to share this article with your colleagues and if you have any feedback feel free to reach out to us.