Use the TEXT function to return a cell reference or number and convert it into text while applying a numeric format. Use the LEN function to count the number of characters in a cell or reference. Use the REPT ( like the word repeat) function to display one or more characters a specific number of times.
- [Voiceover] We're looking at a worksheet called More Text…and in this movie we want to show you…four different functions, text functions,…and they're listed in column A.…There's a function called TEXT,…there's one called VALUE, there's one called LEN,…think of the word length, we've got that to the right,…and there's a function called REPT,…think of the word repeat.…In cell A1, you can imagine seeing something…like this on an invoice, you bought 425 items.…But as we double-click here, and you can see it…in the formula bar too,…this is two different text strings…combined with the data in cell A4.…
It works perfectly, not a problem.…Spacing is there, if the number's bigger for example…it'll still work, so I make that be,…you know, for the moment 1400, that works fine too.…Undo that, command Z.…Now in the second entry here this is set up,…but it's not quite complete yet.…What we want to be able to do here…is to multiply those two items…and put it into the list here.…So following the double quote there…I'm going to put in the ampersand symbol, meaning and,…
Author
Dennis Taylor
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome46s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Use other utility text functions: LEN, REPT, VALUE, TEXT