How To Use Excel Replace Function

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.

How to use excel replace function. Replace old text start number of chars new text parameters or arguments old text the original string value. The syntax for the replace function in microsoft excel is. The replace function is useful for replacing text at a known location in a given string. Start num tells excels where the text you want to replace starts within the cell. Num chars is the number of characters you want to replace.

Double click on replace function. 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 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. For example the following formula replaces 4 characters starting at the 3rd character. Replace xyz123 4 3 456 returns xyz456.

Number of chars the number of characters to replace in old text. Start the position in old text to begin replacing characters.