Microsoft Office Tutorials and References
In Depth Information
For example, =REPLACE(“Chris”,1,5,”Scott”) would result in Scott. Where 1 represents
the first character in Chris and 5 is the number of characters in Scott. If you entered the
formula =REPLACE(“Chris”,2,5,”Scott”) the result would be Cscott. You could also replace
the names with cell references such as: =REPLACE(C5,1,5,D5) . In this example, the result
would replace the C5’s text string starting with 1 to D5’s text string up to 5.
REP REPT repeats text a given number of times.
The REPT function repeats text in a cell as many times as you specify.
This is the text you want to repeat.
This number times specifies the number of times you want to repeat
=REPT(“X”,5) would result in XXXXX.
=REPT(“Stop”,2) would result in StopStop.
=REPT(C1,2) would result in the cell reference text repeated twice.
To use the REPT function correctly, the number you provide must be a positive number and
cannot exceed 255 characters.
RIGHT returns the last character or characters in a text string.
The RIGHT function returns the rightmost characters in a text string. The text can be in the
form of text within the formula or as a cell reference. (Also see LEFT earlier in this chapter.)
The NUM_CHARS argument is the number of characters to return.
TEXT This is the text string or word, or even sentence you want to extract
NUM_CHARS This indicates the number of characters you want to extract starting from
the right moving left.
=RIGHT(“Patrick”,4) would return rick.
Notice the example in Figure 12.10. The RIGHT function used with the LEN and FIND functions
can be used to extract text from the cell. Where LEN counts the characters in the text string
including spaces, FIND locates the space to the left of the rightmost text string and returns a
result of the last word, state, city, and so on.