Excel: REPLACE Function

REPLACE

This function in Excel replaces characters specified by location in a given text string with another text string. The REPLACE function is useful when the location of the text to be replaced is known or can be easily determined. This function takes four separate arguments. The first argument, old_text, is the text string to be processed. The second argument, start_num is the numeric position of the text to replace. The third argument, num_chars, is the number of characters that should be replaced. The last argument, new_text, is the text to use for the replacement. REPLACE function replaces a part of a text string, based on the number of characters you specify, with a different text string. REPLACE function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the REPLACE function can be entered as part of a formula in a cell of a worksheet. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

Arguments of REPLACE Function are:

old_text - The text to replace.

start_num - The starting location in the text to search.

num_chars - The number of characters to replace.

new_text - The text to replace old_text with.