Microsoft Office Tutorials and References
In Depth Information
Changing Text
Here’s how to use TEXT:
1. Position the cursor in the cell where you want the results to appear.
2. Enter =TEXT( to begin the function entry.
3. Click a cell that contains a number or a date, or enter its address.
4. Enter a comma ( ,).
5. Enter a " , and then enter a formatting pattern.
See the Format Cells dialog box (in the Custom category on the Number
tab) for guidance.
6. Enter a " after the pattern is entered.
7. Type a ), and press Enter.
The VALUE function does the opposite of TEXT — it converts strings to
numbers. (This is not to say text such as twenty, but numbers that have been
formatted as text.) Excel does this by default anyway, so I don’t cover the
VALUE function here. You can look it up in Excel’s Help system if you’re
curious about it.
Repeating text
REPT is a nifty function that does nothing other than repeat a string of
text. REPT has two arguments:
The string or a reference to a cell that contains text
The number of times to repeat the text
REPT makes it a breeze to enter a large number of repeating characters.
Figure 16-7 shows how this works. Cells B14 and B15 contain important
summary information. To make this stand out, a string of asterisks (*) has been
placed above and below, respectively, in B13 and B16. The REPT function
was used here, with this formula: =REPT(“*”,120). This simple function
has removed the drudgery of having to enter 120 asterisks.
Try it out:
1. Position the cursor in the cell where you want the results to appear.
2. Enter =REPT( to begin the function entry.
3.Eitherclickacellthatcontainstext,orentertextenclosedindouble
quotationmarks.
Search JabSto ::




Custom Search