what you're looking for is SUBSTITUTE:
=SUBSTITUTE(A2,"Author","Authoring")
Will substitute Author for Authoring without messing with everything else
Answer from DarkAjax on Stack OverflowAblebits
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 - The SUBSTITUTE function in Excel replaces one or more instances of a given character or text string with a specified character(s). The syntax of the Excel SUBSTITUTE function is as follows: SUBSTITUTE(text, old_text, new_text, [instance_num]) The ...
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!
Find and Replace part of string
=SUBSTITUTE (A1,"/","-") More on reddit.com
6
1
July 27, 2022Adding data from one CSV file to another - equivalent to VLOOKUP etc
I don't think you really need to go the Regex route here. Using Where-Object should be enough, and simpler imo. Also, and this is personal preference, but I never like relying on an external counter to manage accessing array objects when I can avoid it. Try the below and see how that works for you. Feel free to shorten the variable names, I was just being descriptive for clarity.
ForEach($Entry in $Addresses)
{
$PhoneNumbersLineObj = $PhoneNumbers | Where-Object {$_.Name -like "$($Entry.Name)"}
$Entry.PhoneNumber = $PhoneNumbersLineObj.PhoneNumber
}
More on reddit.com 4
5
May 10, 2016How to replace text in (part of) a cell with text from another cell
u/mezzoforte17 - Your post was submitted successfully. Please read these reminders and edit to fix your post where necessary: 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 Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. 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
12
2
June 26, 2021Power Query - How to replace a value with wildcard string
Use add column from example, delete the original column and rename the added column to the original column name. = Table.AddColumn(Source, "Custom", each let splitTestPort = List.Reverse(Splitter.SplitTextByDelimiter("ae", QuoteStyle.None)([Test_Port])), splitTestPort2 = List.Reverse(Splitter.SplitTextByDelimiter("irb.", QuoteStyle.None)([Test_Port])), splitsplitTestPort20 = List.Reverse(Splitter.SplitTextByDelimiter("[", QuoteStyle.None)(splitTestPort2{0}?)) in Text.Combine({Text.End(splitTestPort{1}?, 1), Text.Combine(List.Alternate(splitsplitTestPort20, 1, 1, 1), "[")}), type text) More on reddit.com
8
2
November 22, 2022How to Find and Replace a Specific Word Within a String of ...
How to Use the REPLACE Function in Microsoft Excel! ...
07:50
How to SUBSTITUTE and REPLACE text in Excel - YouTube
06:06
The BEST Way to REPLACE Text in Excel FAST! - YouTube
05:46
Excel Replace Text with New Text or Blank - YouTube
Microsoft Support
support.microsoft.com › en-us › excel › functions › substitute-function
SUBSTITUTE function - Excel 2021
... Excel for Microsoft 365 Excel ... 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 location in ...
Exceljet
exceljet.net › home › functions › substitute function
Excel SUBSTITUTE function | Exceljet
January 23, 2026 - The Excel REPLACE function replaces characters at a specified position in a given text string with another text string.
Microsoft Support
support.microsoft.com › en-us › office › substitute-function-6434944e-a904-4336-a9b0-1e58df3bc332
SUBSTITUTE function | Microsoft Support
... Excel for Microsoft 365 Excel ... 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 location in ...
Microsoft Support
support.microsoft.com › en-us › excel › functions › replace-function
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 - Both of them replace one or more characters in a text string with another text string. The difference lies in how the first string is identified. REPLACE selects the first string based on the position. So you might replace four characters, starting with the sixth character in the string. SUBSTITUTE selects based on whether the string matches a predefined search. You might tell Excel to replace any instance of “FA” with “LU” for example.
Corporate Finance Institute
corporatefinanceinstitute.com › home › resources › replace function
REPLACE Function - Formula, Examples, How to Use Replace
May 11, 2026 - The REPLACE Function[1] is categorized under Excel TEXT functions. The function will replace part of a text string, based on the number of characters you specify, with a different text string.
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.
ExtendOffice
extendoffice.com › home › office tips › excel tips
How to use Replace function to replace and add string in Excel?
October 21, 2024 - If you want to add new character into specific locations of a string as below screenshot shown. ... Select a cell which you will place the result and type =REPLACE(REPLACE(A34,4,0,"-"),8,0,"-"), drag fill handle over the cells you use. See screenshot shown. Use Kutools in your preferred language ...
YouTube
youtube.com › mike thomas
How to Replace Part of a Text String in Excel Using SUBSTITUTE and REPLACE Functions - YouTube
Have you ever needed to replace part of a string (i.e. text entry) with something else, across multiple cells? For example: You need to replace every occurre...
Published: May 11, 2022
How To Excel
howtoexcel.org › how-to-find-and-replace-multiple-text-strings-within-a-text-string
How To Find And Replace Multiple Text Strings Within A Text String | How To Excel
Function REPLACETEXTS(strInput As String, rngFind As Range, rngReplace As Range) As String Dim strTemp As String Dim strFind As String Dim strReplace As String Dim cellFind As Range Dim lngColFind As Long Dim lngRowFind As Long Dim lngRowReplace As Long Dim lngColReplace As Long lngColFind = rngFind.Columns.Count lngRowFind = rngFind.Rows.Count lngColReplace = rngFind.Columns.Count lngRowReplace = rngFind.Rows.Count strTemp = strInput If Not ((lngColFind = lngColReplace) And (lngRowFind = lngRowReplace)) Then REPLACETEXTS = CVErr(xlErrNA) Exit Function End If For Each cellFind In rngFind strFind = cellFind.Value strReplace = rngReplace(cellFind.Row - rngFind.Row + 1, cellFind.Column - rngFind.Column + 1).Value strTemp = Replace(strTemp, strFind, strReplace) Next cellFind REPLACETEXTS = strTemp End Function
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 - We need to replace the number “517” ... “ABC987”. The Excel REPLACE function is a Text function thathelps users replace an old text character or an entire string with a new set of characters or strings....
Reddit
reddit.com › r/excel › find and replace part of string
r/excel on Reddit: Find and Replace part of string
July 27, 2022 -
Hi hope someone can point me in the right direction.
I have a spreadsheet I need to change certain characters of a string, so say I have AA/00/BB/11 and I need to change the "/" to a "-" so it would look like AA-00-BB-11 how could I achieve this? I don't want to have to do it manually.
Thanks
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," ","-")
Exceljet
exceljet.net › home › functions › replace function
Excel REPLACE function | Exceljet
January 23, 2026 - In the example shown, the formula in C6 is: =REPLACE(B6,1,24,"") which replaces the first 24 characters in the text with an empty string (""). The Excel SUBSTITUTE function replaces text in a given string by matching.
ExcelFind
excelfind.com › excel-functions › excel-replace-function
How to use the Excel REPLACE function - ExcelFind.com
February 12, 2024 - The Excel REPLACE function replaces part of a text string with a different text string.
WPS Office
wps.com › academy › how-to-replace-text-in-excel-quick-tutorials-1864703
How to replace text in excel | WPS Office Academy
February 13, 2023 - The Excel REPLACE function substitutes another text string for the characters in a given text string that are specified by location. To search for something in your workbooks, such as a certain number or text string, use Excel's Find and Replace tools. You have two options: either find the ...
Contextures
contextures.com › formulas › substitute or replace
Fix Text Excel SUBSTITUTE and REPLACE Functions Examples
September 18, 2025 - The SUBSTITUTE function is in the Text category of Excel functions, and it replaces old text with new text, in a text string.
ExcelHelp
excelhelp.com › home › general vba › excel replace function
Excel Replace Function: Replace a String of Characters | Excel Help
May 23, 2020 - Excel Replace function is used to replace a character or string of characters within another string. Learn more about this Excel function here!