How To Use: REPLACE Function

The REPLACE Function replaces all or part of a text string with another string.In simple terms, it replaces text based on location.

This function is an inbuilt function in Microsoft Excel and is categorized as a String/Text Function. As a worksheet function, you can enter the REPLACE function as part of a formula in a cell.

Syntax for REPLACE Function

=REPLACE (old_text, start_num, num_chars, new_text)

Arguments

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.

I have created the infographics for REPLACE Function. With the help of these infographics, you can easily learn step by step process for using this excel functions.

Furthermore, Excel consists of many inbuilt functions which are helpful in the analytical and statistical study of number.

Simply follow the instructions in the infographics below:

You can use the REPLACE function when you want to replace text based on its location in a string.

Use FIND or SEARCH to find the location of text to replace it it’s not known in advance.

SUBSTITUTE can be used to replace text based on content.

Note that the Replace Function is not suitable for languages that use the double-byte character set (e.g. Chinese, Japanese, Korean). These languages should use the ReplaceB function.

To learn other function like NETWORKDAYS, EDATE and ISTEXT Functions, please click on the name of the function.

Additionally, you can download other accounting templates like Cash Book with VAT, Sales Revenue Analysis Template and Trial Balance from here.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.