REPLACE Formula in Excel

 

What Does It Do ?

This function replaces a portion of text with a new piece of text.

You need to specify where the replacement should start, how many characters to remove and what the new replacement text should be.

image

Syntax

=REPLACE(OriginalText,StartPosition,NumberOfCharactersToReplace,NewText)

Formatting

No special formatting is needed.

No comments:

Post a Comment