The arguments for REPLACE are configured as follows:
The behavior or REPLACE is automatic.
The general form of the formula is:
where N is the number of characters to remove.
The result is used by RIGHT to extract the correct number of characters from the RIGHT.
This only works when the value returned by RIGHT contains just numbers.
For example =REPLACE(“XYZ123”,4,3,“456”) returns “XYZ456”.
For example, =RIGHT(“apple”,3) returns “ple”.
LEN will also count characters in numbers, but number formatting is not included.
For example, =LEFT(“apple”,3) returns “app”.
