Thursday, December 12, 2019

Replace (Replaces characters within text)













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.
Syntax
=REPLACE(OriginalText,StartPosition,NumberOfCharactersToReplace,NewText)
Formatting
No special formatting is needed.

No comments:

Post a Comment