Highline Excel 2016 Class 08

Text Formulas and Text Functions to Join and Extract Data

DESCRIPTION

In this video learn about:
(00:12) Introduction
(00:46) Text Formulas: Ampersand to Join Items together
(01:38) Text Functions to extract partial text items from a larger text item.
(02:57) Extract State with LEFT function
(04:07) Extract Zip Code with RIGHT function
(04:59) Extract First Name with LEFT and SEARCH functions
(06:46) Extract Last Name with RIGHT, LEN and SEARCH functions
(08:50) Extract Product with LEFT and SEARCH functions
(10:07) Extract Region with MID and 3 SEARCH functions
(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
(15:34) TRIM function to remove extra spaces.
(16:22) Create Serial Number Date from ISO Date using DATE, LEFT, MID and RIGHT functions.
(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.
(22:00) TEXT function and Custom Number Formatting to create labels
(26:02) Text Formulas: TEXTJOIN Excel 2016 Function
(29:05) Summary

WORKBOOKS

Download “Highline Excel 2016 Class 08” Highline-Excel-2016-Class-08.zip – Downloaded 36 times – 568 KB







Be the first to comment

Leave a Reply