REPLACE Function (Functions in Excel)
Original Text | Start Position | Characters To Replace | New Character | Modified Text | |
ABCDEFGH | 2 | 1 | x | AxCDEFGH | =REPLACE(C4,D4,E4,F4) |
ABCDEFGH | 2 | 5 | x | AxGH | =REPLACE(C5,D5,E5,F5) |
ABCDEFGH | 2 | 1 | hello | AhelloCDEFGH | =REPLACE(C6,D6,E6,F6) |
ABCDEFGH | 2 | 5 | hello | AhelloGH | =REPLACE(C7,D7,E7,F7) |
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. |
0 comments:
Post a Comment