Microsoft Support
support.microsoft.com › en-us › office › substitute-function-6434944e-a904-4336-a9b0-1e58df3bc332
SUBSTITUTE function | Microsoft Support
This article describes the formula syntax and usage of the SUBSTITUTE function in Microsoft Excel. Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific ...
Ablebits
ablebits.com › ablebits blog › excel › find & replace › using excel replace and substitute functions - formula examples
Using Excel REPLACE and SUBSTITUTE functions - formula examples
March 21, 2023 - New_text - the replacement text. For example, to change the word "sun" to "son", you can use the following formula: ... And if you put the original word in some cell, say A2, you can supply the corresponding cell reference in the old_text argument: ... Note. If the start_num or num_chars argument is negative or non-numeric, an Excel Replace formula returns the #VALUE!
Replace text within a formula?
Greetings all. I have multiple (20) worksheets, each with approximately 50 formulas. The formulas are all the same currently, in that they reference a particular sheet, call it Region 1. Now, I would like to be able to change this to Region 2, Region 3, etc, depending upon the worksheet that... More on mrexcel.com
15
0
April 28, 2003Is it possible to use replace in formulas?
u/Nevio28 - 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. More on reddit.com
10
2
March 17, 2022Excel: replace part of cell's string value - Stack Overflow
I know this is old but I had a ... find and replace version. It turns out that you can nest the substitute method like so: =SUBSTITUTE(SUBSTITUTE(F149, "a", " AM"), "p", " PM") In my case, I am using excel to view a DBF file and however it was populated has times like this: ... So I just made a new column and put that formula in it to convert ... More on stackoverflow.com
How do I replace text as an =function in excel?
u/johndowlelxdxdxdxdxd - 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. More on reddit.com
22
1
September 11, 202100:58
REPLACE function in Excel - YouTube
05:46
Excel Replace Text with New Text or Blank - YouTube
08:12
Use Find and Replace with formulas in excel - YouTube
09:01
Using the Excel SUBSTITUTE Function - YouTube
00:59
How to Replace Words in Excel - YouTube
17:43
8 Awesome Find and Replace Tricks in Excel (Advanced) - YouTube
Microsoft Support
support.microsoft.com › en-us › office › replace-function-8d799074-2425-4a8a-84bc-82472868878a
REPLACE function | Microsoft Support
Syntax: REPLACE(old_text, start_num, num_chars, new_text) REPLACEB(old_text, start_num, num_bytes, new_text)
Spreadsheeto
spreadsheeto.com › home › blog › how to replace characters, text, and strings in excel
How to Replace Characters, Text, and Strings in Excel
August 30, 2024 - Wrap up the formula with an end parenthesis and press Enter. Now, the “29FA” part of the old product ID is replaced with “39LU”. ... If you need the replacement text to be shorter or longer than the text it’s replacing, you can have a different length in the 3rd and 4th argument of REPLACE.
Microsoft Support
support.microsoft.com › en-us › excel › functions › substitute-function
SUBSTITUTE function - Excel 2021
This article describes the formula syntax and usage of the SUBSTITUTE function in Microsoft Excel. Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific ...
ExcelDemy
exceldemy.com › home › excel formulas › how to replace text in excel formula (7 methods)
How to Replace Text in Excel Formula (7 Methods) - ExcelDemy
July 15, 2024 - We have two formulas in the Discounted Price column and >2000 or not column, and we want to demonstrate how to change the text string or numeric string in these formulas. We have used the IF function in a formula and received Yes as the result for the prices that are greater than 2000. If you want to replace Yes with Greater than 2000 in the formula manually:
MrExcel
mrexcel.com › forums › question forums › excel questions
Replace text within a formula? | MrExcel Message Board
April 28, 2003 - Next, select the range whose formulas you want to change. Click on Edit > Replace, type in Region 1 in Find what; and Region 2 or whatever in Replace with, click Replace All and that should do it.
Corporate Finance Institute
corporatefinanceinstitute.com › home › resources › replace function
REPLACE Function - Formula, Examples, How to Use Replace
May 11, 2026 - The REPLACE function in Excel replaces part of a text string with a different text string, useful for modifying variable text data. Its syntax is =REPLACE(old_text, start_num, num_chars, new_text). The function is particularly helpful in financial ...
Exceljet
exceljet.net › home › functions › substitute function
Excel SUBSTITUTE function | Exceljet
January 23, 2026 - The Excel SUBSTITUTE function replaces text in a given string by matching. You can use SUBSTITUTE to replace or completely remove matched text. SUBSTITUTE is case-sensitive and does not support wildcards.
Exceljet
exceljet.net › home › functions › replace function
Excel REPLACE function | Exceljet
January 23, 2026 - This is accomplished by combining ... to repeat an asterisk (*) once for each number we are replacing, like this: REPT("*",LEN(B5)-4). Excel contains several functions that can help you find and replace text:...
Software-testing-tutorials-automation
software-testing-tutorials-automation.com › home › excel guide › how to replace text in excel (tools + formula fixes)
How to Replace Text in Excel (Tools + Formula Fixes)
March 24, 2025 - You have a product list, but some ... + A). Press Ctrl + H to open Find & Replace. ... Click Replace All. ... The SUBSTITUTE formula allows you to replace text within a cell, even when you have multiple values to change...
Reddit
reddit.com › r/excel › is it possible to use replace in formulas?
r/excel on Reddit: Is it possible to use replace in formulas?
March 17, 2022 -
Hi guys, as of the title I'd like to know if it is possible to find and replace parts of a formula, rather than the cell content. For instance, if I have a compiled sheet where in row A1:A20 the formulas are referred to a set of sheets, but I want to change the reference to another set, is it possible to find and replace the reference appearing in the formula instead of changing manually every formula in every cell?
Top answer 1 of 5
4
Ctrl+H (Find and Replace) In "Look in:", select "Formulas"
2 of 5
1
u/Nevio28 - 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.
Corporate Finance Institute
corporatefinanceinstitute.com › home › resources › substitute function
SUBSTITUTE Function - Formula, Example, Excel
May 22, 2026 - The SUBSTITUTE function in Excel replaces occurrences of specified text within a string. Its syntax is =SUBSTITUTE(text, old_text, new_text, [instance_num]), where instance_num specifies which occurrence to replace.
Contextures
contextures.com › formulas › substitute or replace
Fix Text Excel SUBSTITUTE and REPLACE Functions Examples
September 18, 2025 - Here are a few examples of when to use each function, and there are more examples further down the page. Use the SUBSTITUTE function if you need to make one of the following changes: Replace a specific string of text in ...
Top answer 1 of 4
75
what you're looking for is SUBSTITUTE:
=SUBSTITUTE(A2,"Author","Authoring")
Will substitute Author for Authoring without messing with everything else
2 of 4
30
What you need to do is as follows:
- List item
- Select the entire column by clicking once on the corresponding letter or by simply selecting the cells with your mouse.
- Press Ctrl+H.
- You are now in the "Find and Replace" dialog. Write "Author" in the "Find what" text box.
- Write "Authoring" in the "Replace with" text box.
- Click the "Replace All" button.
That's it!
Exceljet
exceljet.net › home › formulas › replace one character with another
Replace one character with another - Excel formula | Exceljet
October 22, 2023 - To replace or substitute all occurrences of one character with another character, you can use the SUBSTITUTE function. In the example shown, the formula in C6 is: =SUBSTITUTE(B6," ","-")
LiveFlow
liveflow.com › product-guides › replace-formula-in-excel-explained
REPLACE Formula in Excel: Explained | LiveFlow
The REPLACE function in Excel is used to replace a specified number of characters within a text string with a new text string. It is used when you need to make changes to a large amount of text, such as correcting spelling errors, changing names or addresses, or removing unwanted characters. ... The REPLACE formula ...
ElyxAI
getelyxai.com › excel formulas › text › replace
REPLACE Function in Excel: Complete Guide | ElyxAI
=REPLACE(old_text, start_num, num_chars, new_text) - Matches Excel syntax exactly · Master Excel text functions with ElyxAI's interactive formula builder and real-time validation.
Wall Street Mojo
wallstreetmojo.com › home › excel resources › text functions in excel › excel replace function
Excel REPLACE Function - How To Use? Examples and Template.
May 21, 2026 - Choose an empty cell for the output. Type =REPLACE( in the cell. [Alternatively, type =R or =RE, and select the REPLACE function from the suggestions given by Excel] Enter the arguments as cell values or cell references.
Dfwexcel
dfwexcel.com › excel-formulas › replace-text
Find and Replace Text in a Formula - Excel Experts
June 16, 2026 - To swap text inside a formula — reformat phone numbers, fix a recurring typo, change a delimiter — use SUBSTITUTE (replace by matching text) or REPLACE (replace by position).