Microsoft Office Tutorials and References
In Depth Information
Changing Text
Typically, you would enter a character (such as a period or an asterisk),
but any text will work.
4. Enter a comma ( ,).
5.Enteranumbertotellthefunctionhowmanytimestorepeatthetext.
6. Type a ), and press Enter.
Figure 16-7:
Repeating
text with
the REPT
function.
Swapping text
Two functions — REPLACE and SUBSTITUTE — replace a portion of a string
with other text. The functions are nearly identical in concept but are used in
different situations.
Both REPLACE and SUBSTITUTE replace text within other text. Use REPLACE
when you know the position of the text you want to replace. Use SUBSTITUTE
when you don’t know the position of the text you want to replace.
REPLACE
REPLACE takes four arguments:
The target string as a cell reference
The character position in the target string at which to start replacing
The number of characters to replace
The string to replace with (does not have to be the same length as the
text being replaced)
For example, if cell A1 contains the string Our Chicago office has
closed., then the formula =REPLACE(A1,5,7,”Dallas”) returns the
string Our Dallas office has closed.
Search JabSto ::




Custom Search