Custom Number Formatting & Text Functions, (33 Examples)

Topics: Data Validation, Text Formulas, Date Formulas, Flash Fill and Array Formulas

Topics in this video:
1. 23 Examples of Custom Number Formatting (00:18 min)
2. Custom Number Formatting For Unit Price for Invoice (15:33 min)
3. Three TEXT function examples for creating labels (16:26 min)
4. Extract First Name formula using LEFT and SEARCH (18:55 min)
5. LEN function (20:13 min)
6. Extract Last Name formula using REPLACE and SEARCH functions (21:38 min)
7. Extract Last Name formula using SUBSTITUTE function (23:15 min)
8. Create e-mail address from employee names using LOWER, LEFT, SEARCH, REPLACE functions (42:10 min)
9. Flash Fill to create e-mail address from employee names (26:00 min)
10. TEXT function to create time from Text Time Items and the backslash character to insert a character into a Custom Number formatting (Barry Houdini Trick) (27:52 min)
11. Flash Fill to create time from Text Time Items (29:43 min)