Excel Magic Trick 1281


TEXTJOIN & CONCAT New Excel 2016 functions (14 Examples of Joining Items)

DESCRIPTION

Learn about the new Excel 2016 functions TEXTJOIN and CONCAT. Compare and contrast these newer functions to the older methods of using the CONCATENATE function and the Ampersand. See some amazing new and more efficient uses that TEXTJOIN and CONCAT have over the earlier methods.

(00:47) Ampersand Example: Join First, Middle and Last name when there are no empty cells.
(01:18) CONCATENATE Function Example: Join First, Middle and Last name when there are no empty cells.
(02:50) CONCAT Function Example: Join First, Middle and Last name when there are no empty cells.
(03:30) TEXTJOIN Function Example: Join First, Middle and Last name when there are NO empty cells. Learn about the delimiter argument, ignore_empty argument, text1 argumnet, text2 arguments.
(04:34) TEXTJOIN Function Example: Join First, Middle and Last name when there ARE EMPTY CELLS.
(05:27) CONCAT Function Example: Join three elements to make up Product Code.
(05:56) CONCAT Function Example: Join single cell, delimiter and a range of cells to create a Product Code.
(06:43) Ampersand Example: Join three items with two different delimiters to create a Product Code.
(07:11) TEXTJOIN and Array Constant Example: Join three items with two different delimiters to create a Product Code.
(07:56) TEXTJOIN and Range of Cells that contains different delimiters: Join three items with two different delimiters to create a Product Code.
(08:19) TEXTJOIN function to join 3 items with a delimiter to create plywood label
(08:39) Ampersand Example: Join 20 e-mails with a semi-colon as a delimiter so we can past e-mails into E-mail To textbox so send out multiple e-mails.
(09:24) TEXTJOIN Example: Join 20 e-mails with a semi-colon as a delimiter so we can past e-mails into E-mail To textbox so send out multiple e-mails.
(09:53) TEXTJOIN to join records from a database with a comma delimiter to create single column that contains records.

WORKBOOKS

Download “Excel Magic Trick 1281-1300.zip” Excel-Magic-Trick-1281-1300.zip – Downloaded 767 times – 4 MB




Be the first to comment

Leave a Reply