-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Variable Replace Space with Underscore VBA
- Thread starter fraz627
- Start date
DanteAmor
Well-known Member
- Joined
- Dec 3, 2018
- Messages
- 18,487
- Office Version
- 2019
- Platform
- Windows
Like this:
Or.
Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string.
To replace text or numbers, press Ctrl+H, or go to Home > Editing > Find & Select > Replace.
More info:
support.microsoft.com
| varios 10dic2024.xlsm | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | ||||
| 2 | need a way to replace spaces from a String variable with Underscores | need_a_way_to_replace_spaces_from_a_String_variable_with_Underscores | ||
Hoja4 | ||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B2 | B2 | =SUBSTITUTE(A2," ","_") |
Or.
Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string.
To replace text or numbers, press Ctrl+H, or go to Home > Editing > Find & Select > Replace.
More info:
Find or replace text and numbers on a worksheet - Microsoft Support
How to find and replace text and numbers in an Excel worksheet or workbook.
support.microsoft.com
Upvote
0
