SUBSTITUTE it is easy to use
=SUBSTITUTE( SUBSTITUTE(I2,",","_") ," ","_")
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.
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 - Select the range of cells where you want to replace spaces (B2:B7), and in the Menu, go to Edit > Find and replace (or use the keyboard shortcut CTRL + H). In the pop-up window, (1) enter space in the Find box and (2) underscore (_) in the Replace ...
replace - Excel formula to remove comma, spaces, period and add a text - Stack Overflow
I need to use a combination of excel formulas in one cell to remove commas, periods, spaces and replace with underscore. More on stackoverflow.com
Excel formula - remove commas, hyphens, spaces and replace with underscore
I have data like this: Reyes, Ma. Luisa Jun-Oh, Junee Carter, John Jr. I need to use a combination of excel formulas in one cell to remove commas, periods, spaces and replace with underscore. Also need to add text after the names (to be used as PDF filename). Expected output... More on mrexcel.com
7
0
July 4, 2020Replacing spaces in text strings in Excel with Underscores
Find answers to Replacing spaces in text strings in Excel with Underscores from the expert community at Experts Exchange More on experts-exchange.com
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, 202302:19
Replace Spaces with a Dash or Underscore in Excel (3 Ways) - YouTube
How to Replace Part of a Text String in Excel Using SUBSTITUTE ...
01:10
How to replace blank space with nothing/ underscore/ dash/ comma ...
Convert Space to Underscore in Microsoft Excel
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.
Avantix Learning
avantixlearning.ca › home › how to replace spaces in excel with underscores (_), dashes (-) or other values
How to Replace Spaces in Excel with Underscores (_), Dashes (-) or Other Values
April 13, 2022 - In Excel, you can replace spaces in text strings with underscores, dashes or other values using Find and Replace, by creating a formula or by using Flash Fill.
YouTube
youtube.com › pdf tutorial
How to replace space with underscore in excel - YouTube
Assalamu Walaikum,In this video I will show you, How to replace space with underscore in excel. Let's get started.I hope you enjoyed this video please subsc...
Published: May 13, 2024
Views: 1
YouTube
youtube.com › watch
Replace space with underscore in Excel - YouTube
The video offers a quick tutorial on how to replace space with underscore in Excel.
Published: June 12, 2022
Excel Forum
excelforum.com › excel-general › 728119-how-to-copy-text-from-another-cell-and-replace-space-with-underscore.html
How to copy text from another cell and replace space with underscore
1) Copy the cell(s) to the new location 2) Do a CTRL-H (search replace) to search for spaces and replace with underscores. To do it in a formula: =SUBSTITUTE(A1, " ", "_") ... Microsoft MVP 2010 - Excel Visit: Jerry Beaucaire's Excel Files & Macros If you've been given good help, use the icon ...
The Bricks
thebricks.com › home › resources › how to replace spaces with underscores in excel
How to Replace Spaces with Underscores in Excel - Bricks
February 12, 2025 - Enter Your Criteria: A dialog box will appear. In the "Find what:" field, press the spacebar once. Don't type the word "space," just a literal space character. In the "Replace with:" field, type an underscore ( _ ).
Arab Psychology
scales.arabpsychology.com › psychological scales › how can i replace spaces with underscores in excel?
How Can I Replace Spaces With Underscores In Excel?
April 8, 2024 - 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.
Arab Psychology
scales.arabpsychology.com › home › replace space with underscore in excel
Replace Space With Underscore In Excel
November 18, 2025 - Conversely, in the Replace with field, input a single underscore character (_). Once both fields are correctly populated, clicking the Replace All button executes the command across the highlighted range.
ExtendOffice
extendoffice.com › home › office tips › excel tips
How to replace blank space with nothing/underscore/dash/comma in Excel?
August 29, 2024 - 1. Open all workbooks you will ... pane. See screenshot: 2. In the Advanced Find and Replace pane, go to the Replace tab, and: (1) In the Find what box, please type a space; (2) In the Replace with box, type underscore/dash/comma as you need....
MrExcel
mrexcel.com › forums › question forums › excel questions
Excel formula - remove commas, hyphens, spaces and replace with underscore | MrExcel Message Board
July 4, 2020 - Expected output: Reyes_MaLuisa_Text123; JunOh_Junee_Text123; Carter_JohnJr_Text 123 (no period and trailing space removed) Formula used: =REPLACE(I2,FIND(", ",I2,1),2,"_") & "_Text123" where I is the name field.
Auto VBA
autovbax.com › learn › how-to › replace-space-with-underscore.html
Replace Space With Underscore in Excel & Google Sheets - Auto VBA
Select the range of cells where you want to replace spaces (B2:B7), and in the Menu, go to Edit > Find and replace (or use the keyboard shortcut CTRL + H). In the pop-up window, (1) enter space in the Find box and (2) underscore (_) in the Replace ...
The Bricks
thebricks.com › home › resources › how to replace spaces with underscores in excel using ai
How to Replace Spaces with Underscores in Excel Using AI
February 20, 2025 - The Power Query Editor will open in a new window, displaying your data. Right-click the header of the column where you want to replace spaces. From the context menu, select Replace Values.
MrExcel
mrexcel.com › archive › Formulas › 20395.html
Removing Underscores - Excel Formulas - Board Archive - MrExcel Publishing
Does anyone know how to remove underscores from text by using either a macro or a formula. Thanks for your help. Sam · Posted by Mark W. on June 18, 2001 8:32 AM · =SUBSTITUTE(A1,"_"," ") will replace underscores in cell A1 with a space.
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.
Experts Exchange
experts-exchange.com › questions › 20253590 › Replacing-spaces-in-text-strings-in-Excel-with-Underscores.html
Solved: Replacing spaces in text strings in Excel with Underscores | Experts Exchange
January 10, 2002 - Another option is if you have Word.Copy Columns/Rows to word use the Edit replace option space for underscore.Copy back to excel This sounds like a lot of work but only takes seconds ...Bob
Ucdavis
dw-test.elc.ucdavis.edu › home › jampu
Excel Replace Spaces With Underscores - Data Science Workbench
October 18, 2023 - Click on the Replace button, or use the keyboard shortcut Ctrl + H to open the Find and Replace dialog box. Enter the Space: In the Find what field, enter a space character. You can do this by simply pressing the spacebar once.