How to Use REPLACE Function in Excel (with Example)

How to Use REPLACE Function in Excel?“““`

REPLACE function replaces text from a given string and related to SUBSTITUTE  Function. But REPLACE function is a little bit different to SUBSTITUTE function.

Syntax

=REPLACE (old_text, start_num, num_chars, new_text)

Arguments

  • old_text  – This is the Text where we want to change some characters.
  • start_num – This is the starting point in the text in old_text which we want to change text characters.
  • num_chars – This is the number of characters in old_text that we want to REPLACE with.
  • new_text  – This is the new text_characters will be REPLACE with old_text.

Examples

REPLACE function

Remember

Start Number and number of characters cannot be negative.

This function is designed for use with text strings and returns a text string only. So do not use this function with date, time or a number, cause the unexpected results

Related Function

Excel SUBSTITUTE function

 

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.