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.

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.

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 ( _ ).

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.

July 4, 2020 - let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), #"Replaced Value" = Table.ReplaceValue(#"Changed Type",",","_",Replacer.ReplaceText,{"Column1"}), #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",".","_",Replacer.ReplaceText,{"Column1"}), #"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1"," ","_",Replacer.ReplaceText,{"Column1"}), #"Added Suffix" = Table.TransformColumns(#"Replaced Value2", {{"Column1", each _ & "Text123", type text}}) in #"Added Suffix" ... My data consists of Lastname then a comma and space. Firstly I need the last name to not have spaces or other special characters, then an underscore after.

November 18, 2025 - The combined formula would look like this: =SUBSTITUTE(TRIM(A2), ” “, “_”). This nested approach first normalizes the spacing and then performs the precise space-to-underscore conversion, resulting in perfectly clean data.

February 20, 2025 - You should see the text from A2, but with all spaces replaced by underscores. For instance, "Product Number" becomes "Product_Number." Click on cell B2 again. Hover your mouse over the small green square at the bottom-right corner of the cell (the "fill handle"). Your cursor will turn into a small black plus sign. Click and drag the fill handle down to apply the formula to all the corresponding rows of your data. Alternatively, you can just double-click the fill handle, and Excel will automatically fill it down to the last row of your adjacent data.

October 18, 2023 - In this formula, text is the original ... occurrence of old_text to replace. For example, if you have the formula =SUBSTITUTE("My File Name", " ", "_"), Excel will replace the space in "My File Name" with an underscore, resulting ...

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 ...

May 30, 2025 - To replace spaces with underscores using the REPLACE function, follow these steps: 1. Select the cell or range of cells where you want to replace spaces with underscores. 2. Enter the following formula: `=REPLACE(A1," ","_")`, assuming the text ...

October 18, 2023 - Replace All: Click on “Replace All” to replace all spaces with underscores in your selected range. If you want to keep your original data intact and create a new column with the modified text, you can use the SUBSTITUTE function. Assuming Data: Let’s say your data is in column A. Enter Formula: In a new column (say, column B), enter the following formula in the first cell where you want the modified text to appear:

April 8, 2024 - Another way to replace spaces with underscores in Excel is to use the SUBSTITUTE function. We can type the following formula into cell B2 to replace each space in cell A2 with an underscore:

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.