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?
To get a dash instead of 0 in Google Sheets. Select the cells then click on the Edit menu and select the “Find and Replace” option. In the Find section enter type “0” and in the Replace section type a dash “-” and then click on apply
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 )