In this tutorial, we will learn How to Replace a Space with a Dash in Google Sheets
To replace a space with a Dash in Google Sheets you can use the find and replace option
Let’s go through the steps in detail.
How to Replace a Space with a Dash in Google Sheets: Step by Step Guide
Enclosed are the steps to replace a space with a Dash in Google Sheets.
Step 1: Open Google Sheets.
Step 2: Select all the cells where you need to replace a space with a Dash.

Step 3: Now Click on the Edit menu and select “Find and Replace” from the drop-down
- Click on the Edit menu on the Main menu bar.
- Now from the drop-down options Select “Find and Replace
You can also use the Keyboard Shortcut CTRL + H to open the “Find and Replace ” window.

Step 4: Now in the Find section enter space using the spacebar key and in the Replace section enter a Dash “-“

Step 5: Now Click on Replace all Button
Click on the Replace All button and then click on Done

Once you click on Replace all , it will replace space with a dash in the selected cells on your Google Sheet.
How to Replace a Space with a Dash in Google Sheets(Summary )
Using the preceding steps you can quickly replace a space with a Dash in Google Sheets. Find and replace is the most commonly used substitution method across users.
We hope this tutorial on How to Replace a Space with a Dash in Google Sheets was helpful.
Other FAQs
How do I get a dash instead of 0 in Google Sheets?
Related articles :
How To Import Spreadsheet Into Google Sheets ( Easy to follow Guide)
How To Bold Lines In Google Sheets ( Quick & Easy Guide )
How to Print Gridlines in Google Sheets ( Easy Guide )
How to do VLOOKUP to the left in google sheets ( Easy Guide )