How To Use Excel Replace Function

Double click on replace function.

How to use excel replace function. You can use replace to remove text by specifying an empty string as new text. The syntax of the replace function replace old text start num num chars new text old text is the cell containing the text you want to replace. Replace function in excel replace function in excel is a text function which is an inbuilt function and similar to substitute function this function is used to replace an old text from a string with a new string the input required by this function is the old text new text and the starting numbers and ending numbers of the characters which needs to be replaced. The syntax for the replace function in microsoft excel is. New text the replacement set of characters.

Start the position in old text to begin replacing characters. Replace xyz123 4 3 456 returns xyz456. Select the cell c8 where replace function needs to be applied. Start num tells excels where the text you want to replace starts within the cell. Number of chars the number of characters to replace in old text.

The replace function is useful for replacing text at a known location in a given string. Click the insert function button fx under formula toolbar a dialog box will appear type the keyword replace in the search for a function box replace function will appear in select a function box.