Loading...

Highline Excel 2016 Class 08: Text Formulas and Text Functions to Join and Extract Data

54,735 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 9, 2016

Download Files: https://people.highline.edu/mgirvin/A...
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

Loading...


to add this to Watch Later

Add to

Loading playlists...