try like this:
=INDEX(SUBSTITUTE(A1:A10; "_"; " "))
Automate Excel
automateexcel.com › home › replace space with underscore in excel & google sheets
Replace Space With Underscore in Excel & Google Sheets - Automate Excel
February 27, 2023 - In the Find and Replace window, (1) type a space in Find what box and (2) underscore (_) in the Replace with box.
Reddit
reddit.com › r/sheets › how do i replace blank spaces with a - dash in a column?
r/sheets on Reddit: How do I replace blank spaces with a - Dash in a column?
July 23, 2020 -
I have a google sheet with lots of business names in the column
-
Company name 1
-
Company name 2
-
Company name 3
How do I remove those empty spaces and replace it with a Dash? So that it looks like:
-
Company-name-1
-
Company-name-2
-
Company-name-3
EDIT: solution is to use Edit>find and replace.
Top answer 1 of 2
1
=SUBSTITUTE(cell, " ", "-") Replace "cell" with the reference you're making.
2 of 2
1
Create a new column using the formula below: Tip: SUBSTITUTE(SearchInCellOrRange,"SearchForText","ReplaceWithText") Formula: =SUBSTITUTE(A2," ","-") Here is G Sheets help article for more info Hope that helps
How do I get rid of these unnecessary spaces when I copy/paste this sheet into a text box? May 6, 2025
r/googlesheets last yr.
how to replace every underscore with a space instead?
You can select all the headers, then press ctrl+f -> replace -> find _ replace with space, replace all Its important to select just the headers otherwise you might replace things outside of headers that wasn't intended More on reddit.com
8
0
October 17, 2023google sheets - Combine two cells in a new cell, replace all spaces with dash, and lowercase - Stack Overflow
Trying to combine two cells in a Google spreadsheet, replace all the spaces with a "-", and lowercase everything. Cell 1: GWG-1 Cell 2: Product Name 1 New Cell 3: gwg-1-product-name-1 More on stackoverflow.com
How to remove unwanted spaces - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on More on support.google.com
Source Google Sheets: Replace whitespaces with underscore in stream name
What area the feature impact? Connectors Revelant Information Hello everyone, It would be highly beneficial if we could replace empty spaces in stream names with underscores, similar to how we can ... More on github.com
2
September 19, 202300:37
How to Convert Text to Lowercase Snake Case in Google Sheets - YouTube
01:19
How to replace space with underscore in excel - YouTube
Find and Replace and Trim Whitespace in Google Sheets
03:01
How to Replace Text with a Blank Cell in Google Sheets - YouTube
02:36
How to Replace a Space with a Dash in Google Sheets - YouTube
Top Business Courses
topbusinesscourses.com › home › how to replace spaces with underscores in google sheets
How to Replace Spaces with Underscores in Google Sheets
July 22, 2023 - The formula then replaces all spaces in the cell with underscores, ensuring a clean and structured format. What’s amazing about this formula is you can change the “_” with anything else you want to insert in place of the blank space.
OfficeWheel
officewheel.com › home › google sheets › replace space with dash in google sheets (2 ways)
Replace Space with Dash in Google Sheets (2 Ways) - OfficeWheel
April 9, 2023 - The biggest advantage of this method is that you can use Replace All to automatically replace any value over a given in Google Sheets in a single click. You get to select the effect range of Find and Replace. It can be the entire spreadsheet, the current sheet only, or a specific range of cells. You can replace spaces with not only hyphens (-), but also underscores (_), commas (,) or any combination of delimiters you can think of.
Auto VBA
autovbax.com › learn › how-to › replace-space-with-underscore.html
Replace Space With Underscore in Excel & Google Sheets - Auto VBA
In the Find and Replace window, (1) type a space in Find what box and (2) underscore (_) in the Replace with box.
Automate Excel
automateexcel.com › home › replace space with underscore in excel & google sheets › google-sheets-replace-space-with-underscore
google-sheets-replace-space-with-underscore - Automate Excel
September 27, 2021 - Learn the essentials of VBA with this one-of-a-kind interactive tutorial · Essential VBA Add-in – Generate code from scratch, insert ready-to-use code fragments
CodePal
codepal.ai › formula generator › excel formula: change space into underscore
Excel Formula: Change Space into Underscore - CodePal
October 18, 2023 - Learn how to write an Excel formula for Google Sheets that changes spaces into underscores. This formula uses the SUBSTITUTE function to replace spaces with underscores in a given cell.
Google Support
support.google.com › docs › answer › 3094215
SUBSTITUTE - Google Docs Editors Help
SUBSTITUTE can be used to replace one or all instances of a string within text_to_search.
Arab Psychology
scales.arabpsychology.com › home › how can i replace spaces with dashes in google sheets?
How Can I Replace Spaces With Dashes In Google Sheets?
September 5, 2024 - The easiest way to replace spaces with dashes in Google Sheets is to use the Find and replace function within the Edit tab.
Reddit
reddit.com › r/excel › how to replace every underscore with a space instead?
r/excel on Reddit: how to replace every underscore with a space instead?
October 17, 2023 -
I have TONS of headers that look like the following
owner2_address_1_city
There underscores instead of spaces make it hard to read quickly and make wrapping text useless. is there an easy way to change it to normal text i.e. below:
"owner 2 address 1 city"
Thanks in advance!
Top answer 1 of 3
6
You can select all the headers, then press ctrl+f -> replace -> find _ replace with space, replace all Its important to select just the headers otherwise you might replace things outside of headers that wasn't intended
2 of 3
1
u/Possible_Spy - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
Top answer 1 of 2
19
Your basic formula is:
=LOWER(SUBSTITUTE(A1," ","-"))
We can concatenate two cells together to get the desired output:
=LOWER(SUBSTITUTE(A1&"-"&B1," ","-"))
Google Sheets
2 of 2
4
This formula is dynamic in that it doesnt actually matter how many cells you decide to incluce:
=SUBSTITUTE(LOWER(JOIN("-",A1:A2))," ","-")
Google Support
support.google.com › docs › thread › 188915830 › how-to-remove-unwanted-spaces
How to remove unwanted spaces - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
YouTube
youtube.com › watch
Replace Spaces with a Dash or Underscore in Excel (3 Ways) - YouTube
Video outlines 3 ways to replace spaces with a dash or underscore in Excel. Methods covered include find and replace, the SUBSTITUTE function, and flash fill...
Published: August 25, 2022
Alphr
alphr.com › home › how to remove spaces in google sheets
How To Remove Spaces in Google Sheets
July 10, 2021 - The pop-up window includes text boxes where you would usually enter some text or numbers to find and some text or numbers to replace them with. But in this case, your goal is to remove extra spacing, so click in the Find box and enter one space using your space bar. Next, press the Replace all button in the dialogue box, then click Done. This will remove all the spaces from cell B3. The text will also align to the right of the cell as Google Sheets thinks that the cell contains a number, and numbers right-align by default.
ExcelTips (ribbon)
excelribbon.tips.net › T012488_Using_a_Formula_to_Replace_Spaces_with_Dashes.html
Using a Formula to Replace Spaces with Dashes (Microsoft Excel)
December 3, 2022 - If you need a formula to change spaces to some other character, the SUBSTITUTE function fits the bill. Here's how to use it.
GitHub
github.com › airbytehq › airbyte › issues › 30571
Source Google Sheets: Replace whitespaces with underscore in stream name · Issue #30571 · airbytehq/airbyte
September 19, 2023 - What area the feature impact? Connectors Revelant Information Hello everyone, It would be highly beneficial if we could replace empty spaces in stream names with underscores, similar to how we can with column names. Your assistance with ...
Author: airbytehq
Statology
statology.org › home › how to replace space with underscore in excel
How to Replace Space with Underscore in Excel
August 17, 2023 - Then type Ctrl + H to bring up the Find and Replace feature in Excel. Then type a single space in the Find what box and type a single underscore in the Replace with box.
Statology
statology.org › home › google sheets: how to replace space with dash
Google Sheets: How to Replace Space with Dash
September 5, 2022 - 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:
Bubble
forum.bubble.io › need help
How to convert all the spaces in an input to underscores - Need help - Bubble Forum
February 21, 2023 - Here for this input i want to covert all the spaces to underscores Kindly guide