Table of Contents
In Google Sheets, users can replace spaces with dashes by using the SUBSTITUTE function. This function allows users to specify the cell or range of cells where the spaces are located and the character they want to replace it with. The SUBSTITUTE function can be found under the “Text” category in the function menu. By utilizing this function, users can easily modify their data and replace the spaces with dashes, making it more visually appealing and organized. This feature is especially useful when dealing with large amounts of data and can save users time and effort in manually replacing spaces with dashes.
Google Sheets: Replace Space with Dash
The easiest way to replace spaces with dashes in Google Sheets is to use the Find and replace function within the Edit tab.
The following example shows how to use this function in practice.
Example: Replace Space with Dash in Google Sheets
Suppose we have the following dataset that shows the total sales of various companies:
Suppose we would like to replace the blank cells in the Company column with dashes.
To do so, highlight the cell range A2:A10 as follows:
Next, click the Edit tab and then click Find and replace.
In the new window that appears, type a space in the Find box, then type a dash in the Replace with box:
Then click Replace all and then click Done.
Each of the spaces in the Company column will automatically be replaced by dashes:
Note: Make sure you click Replace all before clicking the Done button. This is a common mistake that people make, which causes the spaces not to be replaced by dashes.
Cite this article
stats writer (2024). How can I replace spaces with dashes in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-replace-spaces-with-dashes-in-google-sheets/
stats writer. "How can I replace spaces with dashes in Google Sheets?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-replace-spaces-with-dashes-in-google-sheets/.
stats writer. "How can I replace spaces with dashes in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-replace-spaces-with-dashes-in-google-sheets/.
stats writer (2024) 'How can I replace spaces with dashes in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-replace-spaces-with-dashes-in-google-sheets/.
[1] stats writer, "How can I replace spaces with dashes in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I replace spaces with dashes in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.