Highline Excel 2016 Class 08: Text Formulas and Text Functions to Join and Extract Data
82.7 هزار بار بازدید -
9 سال پیش
-
Download Files: https://people.highline.edu/mgirvin/AllClasses/218_2016/218Excel2016.htm
In this
Download Files: https://people.highline.edu/mgirvin/AllClasses/218_2016/218Excel2016.htm
In this video learn about:
1. (00:12) Introduction
2. (00:46) Text Formulas: Ampersand to Join Items together
3. (01:38) Text Functions to extract partial text items from a larger text item.
4. (02:57) Extract State with LEFT function
5. (04:07) Extract Zip Code with RIGHT function
6. (04:59) Extract First Name with LEFT and SEARCH functions
7. (06:46) Extract Last Name with RIGHT, LEN and SEARCH functions
8. (08:50) Extract Product with LEFT and SEARCH functions
9. (10:07) Extract Region with MID and 3 SEARCH functions
10. (13:28) Extract Money Amount from end of description Field with RIGHT, LEN and SEARCH functions, and a MATH operation to Convert Text Number Back to a Number
11. (15:34) TRIM function to remove extra spaces.
12. (16:22) Create Serial Number Date from ISO Date using DATE, LEFT, MID and RIGHT functions.
13. (18:45) Create Serial Number Date from ISO Date using TEXT function, Custom Number Format and Math Operation to Convert Text Number back to a Number.
14. (22:00) TEXT function and Custom Number Formatting to create labels
15. (26:02) Text Formulas: TEXTJOIN Excel 2016 Function
16. (29:05) Summary
9 سال پیش
در تاریخ 1395/02/21 منتشر شده
است.
82,721
بـار بازدید شده