Using Excel REPLACE and SUBSTITUTE functions | excel replace text
ThetutorialexplainstheExcelREPLACEandSUBSTITUTEfunctionswithexamplesofuses.SeehowtousetheREPLACEfunctionwithtextstrings,numbersanddates,andhowtonestseveralREPLACEorSUBSTITUTEfunctionswithinoneformula.LastweekwediscussedvariouswaysofusingFINDandSEARCHfunctions[1]withinyourExcelworksheets.Today,wewillbetakingadeeperlookattwootherfunctionstoreplacetextinacellbasedonitslocationorsubstituteonetextstringwithanotherbasedoncontent.Asyoumayhaveguessed,IamtalkingabouttheExcelREPLACEandSUBSTITUTEfuncti...
The tutorial explains the Excel REPLACE and SUBSTITUTE functions with examples of uses. See how to use the REPLACE function with text strings, numbers and dates, and how to nest several REPLACE or SUBSTITUTE functions within one formula.
Last week we discussed various ways of using FIND and SEARCH functions[1] within your Excel worksheets. Today, we will be taking a deeper look at two other functions to replace text in a cell based on its location or substitute one text string with another based on content. As you may have guessed, I am talking about the Excel REPLACE and SUBSTITUTE functions.
Excel REPLACE functionThe REPLACE function in Excel allows you to swap one or several characters in a text string with another character or a set of characters.
REPLACE(old_text, start_num, num_chars, new_text)
As you see, the Excel REPLACE function has 4 arguments, all of which are required.
Old_text - the original text (or a reference to a cell with the or...