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

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.

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.

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.

November 18, 2025 - The second argument, old_text, is the character or string we intend to locate and remove—in this case, a single space enclosed in quotation marks, ” “. Finally, the third argument, new_text, is the character to be inserted in place of the old text, which is the underscore, “_”. To implement this in our dataset, we would enter the formula into cell B2, directly adjacent to the first data point in column A.

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 - The SUBSTITUTE function takes three ... case, we want to replace spaces with underscores, so we use " " as the text to be replaced and "_" as the text to replace it with....

July 4, 2020 - So Reyes, becomes Reyes_ and Jun-Oh becomes JunOh_ Next is the given name,no periods or Spaces so Ma. Luisa becomes MaLuisa then add the underscore and additional text. Need to have Reyes_MaLuisa_Text123; JunOh_Junee_Text123; also need cases like Carter, John Jr. to be converted to Carter_JohnJr_Text123 ... Click to expand... That is pretty vague as it could include a multitude of characters but based on them being periods or hyphens see if this is it ... Thank you for providing me with the formula even if my description was vague.

November 20, 2024 - In the “Replace with” field, ... a backup of your data!</p> If you prefer a formula-based approach, you can use the SUBSTITUTE function....

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.

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

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

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.