1
Highline Excel 2016 Class 08: Text Formulas and Text Functions to Join and Extract Data
29:41
2016-05-10
2
Excel Magic Trick 1281: TEXTJOIN & CONCAT New Excel 2016 functions (14 Examples of Joining Items)
10:54
2016-02-20
3
Excel Magic Trick # 166: Join Text: CONCATENATE function & Ampersand
5:55
2008-12-02
4
Highline Excel Class 13: Text functions & AMPERSAND
19:57
2009-04-05
5
Excel Magic Trick 846: Formula To Reverse First & Last Name When Names Separated by A Space
2:26
2011-12-15
6
Excel Magic Trick 292: Reverse Last & First Name Tricks
6:05
2009-03-16
7
Excel Magic Trick #192: Extract Middle Name Text To Column
2:27
2009-01-09
8
YouTubersLoveExcel#51: VLOOKUP & Variable Labels
6:10
2008-07-07
9
Excel Magic Trick #228: Text Formula & Forced Wrap Text
5:10
2009-01-23
10
YTL Excel #120: Formula To Wrap Text
5:55
2008-09-09
11
Excel Magic Trick # 159: VLOOKUP Duplicates 1st Column
3:59
2008-12-02
12
Excel Magic Trick #113: Nested IF & Short Term Loans
10:22
2008-10-10
13
Excel Magic Trick 393: Remove Last Two Words From Column Of Data
11:06
2009-09-17
14
Excel Magic Trick 427: Determine Day Name For Future Date
6:13
2009-10-26
15
Excel Magic Trick 428: Trouble Entering Dates - Date Syntax
2:29
2009-10-26
16
Excel Magic Trick #191: Extract Middle Name Formula
5:02
2009-01-09
17
Excel Magic Trick 393: Remove Last Two Words From Column Of Data
11:06
2009-09-17
18
Excel Magic Trick #190: Rearrange First Last Name w Formula
3:55
2009-01-09
19
Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Characters
5:45
2010-02-17
20
Excel Magic Trick 531: Extract Numbers from Middle of Text String BB34G to 34 (2 methods)
8:12
2010-02-26
21
Excel Magic Trick 559: Extract Nth Word In Text String
13:18
2010-03-27
22
Excel Magic Trick 561: Wildcards * and ?
4:45
2010-03-27
23
Excel Magic Trick 562: Extract Names - Some Names In List Have Middle Name Some Do Not
7:50
2010-03-27
24
Excel Magic Trick 580: Extract Digits To Right Of Decimal Into Individual Cells
6:03
2010-04-27
25
Excel Magic Trick 948: Lookup Insurance Name from within Parenthesis (Extract Text From Text String)
3:30
2012-07-19
26
Excel Magic Trick 1002: Replace "11" With "13", But Only After Third Dash
6:15
2013-06-13
27
Excel Magic Trick 1019: Formula For Text Month Labels From Serial Date: EDATE, TEXT & COLUMNS
4:01
2013-07-16
28
Excel Magic Trick 1068: TEXT and FIXED functions for Formatting Numbers in Text Formulas
3:37
2014-02-09
29
Excel Magic Trick 1096: Extract Date from Middle of Description, Better Formula
3:56
2014-04-11
30
Excel Magic Trick 1113: Extract All Characters In Cell To Separate Cells: PPPP to P, P, P, P
4:31
2014-05-17
31
Excel Magic Trick 1140: VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels
8:14
2014-09-18
32
Excel Magic Trick 1144 Top 3 TEXT Function uses ISO Date to Date , Text Time To Time , Date To Month
9:54
2014-10-24
33
Excel Magic Trick 1146: Create ISO Dates using TEXT function and Custom Number Format
1:46
2014-10-29
34
Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable
5:23
2015-03-27
35
Excel Magic Trick 1199: Formula to Extract Everything After Last Space: Two Formula Solutions
6:37
2015-05-22
36
Excel Magic Trick 1220: How To Put Double Quotes In Text Formula: Extra Double Quotes Or VLOOKUP
5:45
2015-08-05
37
Excel Magic Trick 1262: Convert Times Values to HHMM Text or Text HHMM Values to Time Values
3:48
2016-01-24
38
Excel Magic Trick 1278: Extract Color From Description (Text String)
3:35
2016-02-14
39
Excel Magic Trick 1282: Lookup And Return Multiple Items to a Single Cell: TEXTJOIN Function
5:12
2016-02-23
40
Excel Magic Trick 1289: Remove “USD” from CSV File Column of Numbers (6 Examples)
14:39
2016-03-11
41
Excel Magic Trick 1295: TEXTJOIN & INDEX Function to create Random Description Codes
3:46
2016-03-21
42
Excel Magic Trick 1300: List All Modes in Single Cell with TEXTJOIN & MODE.MULT
4:21
2016-07-10
43
Excel Magic Trick 1301: Sorted List of Modes in Single Cell with TEXTJOIN Array Formula
7:35
2016-07-11
44
Excel Magic Trick 1302: List Text Modes in Single Cell with TEXTJOIN, HLOOKUP, MATCH & MODE.MULT
6:36
2016-07-13
45
Excel Magic Trick 1304: List Text Modes in Single Cell TEXTJOIN, INDEX, N, IF, MATCH & MODE.MULT
6:14
2016-07-15
46
Excel Magic Trick 1308: Concatenate Items in Rows & Columns from Two-Way Table with TEXTJOIN
2:26
2016-07-21
47
Excel Magic Trick 1328: Case Sensitive Filtering, Adding or Counting: Power Query (Get & Transform)
6:55
2016-10-09
48
Excel Magic Trick 1339: Create Alphabet A – Z: Formula, Power Query, or Custom List?
10:31
2016-11-04
49
Excel Magic Trick 1352: Lookup 3 Items & Return to Single Cell VLOOKUP, INDEX or LOOKUP functions?
18:07
2016-11-30
50
Excel Magic Trick 1356: Lookup 3 Items & Return to Single Cell Helper Column or Power Query?
11:46
2016-12-08
51
Excel Magic Trick 1391: Case Sensitive VLOOKUP? 5 Examples of Excel Case Sensitive Lookup
14:35
2017-03-10
52
Excel Magic Trick 1399: Join All Dates Together in a Cell using TEXTJOIN & TEXT Array Formula
3:54
2017-03-29
53
Excel Magic Trick 1402 Part 4: UNICHAR & UNICODE Functions for Unicode Value
4:43
2017-04-07
54
Excel Magic Trick 1402 Part 3: Power Query to Put Check Mark In Cell If Number Greater Than 0
5:59
2017-04-06
55
Excel Magic Trick 1402 Part 2 Formula to Put Check Mark In Cell If Number Great than 0 without CHAR
3:41
2017-04-05
56
Excel Magic Trick 1402: Formula to Put Check Mark In Cell If Number Greater Than Zero
6:05
2017-04-04
57
Mr Excel & excelisfun Trick 183: Lookup and Return Multiple Items And Join Them In Single Cell
11:00
2017-05-05
58
Excel Magic Trick 1414: Power Query Text.PadStart Function to Correctly Format Account Numbers
6:07
2017-05-06
59
Excel Magic Trick 1423: Power Query Number.ToText Function to Format Numbers as Text
9:15
2017-05-16
60
Excel Magic Trick 1429: Power Query Ranking with Index, Grouping and MIN Function!!!
5:41
2017-05-19
61
Mr Excel & excelisfun Trick 185: Get Text Between First & Last Dash: 4 Methods
14:25
2017-07-07
62
Excel Magic Trick 1460: List All Relative Positions in a Single Cell using TEXTJOIN Array Formula
12:24
2017-09-01
63
Excel Magic Trick 1463: Show Formula in Cell With Excel Functions FORMULATEXT & ISFORMULA
5:59
2017-09-12
64
Mr Excel & excelisfun Trick 186: Does Text Contain Number Digits? Flash Fill, Formula or VBA?
12:23
2017-10-20
65
Excel Magic Trick 1475: Power Query, Formula, Flash Fill: "1-PSD/AFX-12" into "12-AFX/PSD-1"
10:59
2017-12-31
66
Excel Magic Trick 1500: Lookup All Products For Supplier & Join in Single Cell TEXTJOIN & IF
5:54
2018-06-01
67
Excel Magic Trick 1500: Lookup All Products For Supplier & Join in Single Cell TEXTJOIN & IF
5:54
2018-06-01
68
Excel Magic Trick 1506: Power Query to Extract All Numbers Listed in Single Cell and Add for Total
6:41
2018-06-13
69
Excel Formula to Reverse First & Last Name. Better Than Power Query & Flash Fill? - EMT 1581
3:21
2019-07-31
70
Extract Data From Cell with Flash Fill - Excel Magic Trick 1582
1:29
2019-08-01
71
Excel Formula to Increment Numbers: 1-6, 7-12, 13-18 for Raffle Ticket - Excel Magic Trick 1585
4:23
2019-08-08
72
DAX Measure & Data Model PivotTable - List Student Classes in Single Cell –- Excel Magic Trick 1607
4:22
2019-09-24
73
Dynamic Array & Old Array Formulas to Create Student Classes Report - Excel Magic Trick 1608
7:48
2019-09-26
74
Excel Formula for Text Number Label with Lead Zeroes: 010-030, 030-050, 050-070 - EMT 1612
5:24
2019-10-19
75
TEXTJOIN & TEXT Functions working on Multiple Rows or Columns (DOLLAR Function too) EMT 1614
4:41
2019-10-29
76
Split Text By Capital Letters in Excel using Power Query EMT 1617
7:58
2019-11-09
77
Remove Spaces From Column Names in All Tables Automatically in Power Query - EMT 1625
3:46
2019-12-08
78
VLOOKUP & LEFT Functions #N/A Error. And Lookup Code is in List?!? Excel Magic Trick 1627
4:23
2019-12-19
79
Excel FIXED Function Easier than TEXT Function! (DOLLAR Function too). Excel Magic Trick 1635
2:54
2020-01-11
80
TEXTJOIN & MID? LEFT, 2 MID, RIGHT? Excel Formulas to Insert Dashes into Text Excel Magic Trick 1637
3:32
2020-01-17
81
Power Query to Insert Dashes into Text. Flash Fill too! Excel Magic Trick 1638
3:44
2020-01-19
82
REPLACE Function to Insert a Dash Into Text. Flash Fill Too. Excel Magic Trick 1639
2:36
2020-01-31
83
Flash Fill, Array Formula or Power Query? To Insert Dash Between Text & Number. EMT 1641
6:45
2020-02-03
84
Extract Data From Cell, Display Horizontally with Excel Formula. 5 Examples. Excel Magic Trick 1663
6:49
2020-04-28
85
Extract Data From Excel Cell. 4 Different Methods! Excel Magic Trick 1664
10:42
2020-05-01
86
Remove Numbers from Text. Flash Fill, Power Query, Formula or LET Function? Excel Magic Trick 1670
12:18
2020-06-01
87
Multiple Text Modes with Excel Formula. Microsoft 365 Excel and Older Versions too. EMT 1674
6:07
2020-06-29
88
FILTERXML Function to Split Text into Cells. Excel Magic Trick 1685.
5:08
2020-08-25
89
Power Query Split, Add, Combine. Dueling Excel #193 with Mr Excel & Excelisfun
13:27
2020-08-28
90
Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736.
6:21
2021-04-16
91
Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741
2:43
2021-06-22
92
Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742
11:38
2021-06-29
93
Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753
1:58
2021-09-13
94
Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764
10:14
2021-11-01
95
Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765
5:24
2021-11-22
96
Conditional Formatting to Highlight Missing Sequential Incident Numbers. Excel Magic Trick 1766
11:09
2021-12-15
97
Excel Text To Columns or Split to Rows: Worksheet Formula or Power Query? Excel Magic Trick 1795
3:02
2022-08-07
98
Excel Filter By Month: Filter feature or FILTER function? Amazing Dynamic Formula Solution. EMT 1796
7:50
2022-08-09
99
Text Formulas & Functions in Excel Worksheet and Power Query - 365 MECS 06
34:27
2022-09-14
100
Show all Formulas in Single Column – Awesome Model Documentation Trick - Excel Magic Trick 1800
3:52
2022-10-13
101
Extract All Digits from Range & List in Column - Excel Magic Trick 1812 #shorts
2:45
2023-01-16
102
Excel Formula to Add 12,12,12,12 from a cell to get 48!?!? Excel Magic Trick 1817
5:38
2023-02-21
103
FILTER Function with List of Partial Text Contains Criteria & Not Contains Criteria. EMT 1837
6:10
2023-09-03
104
Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860
3:38
2024-07-12
105
Array of Delimiters in TEXTJOIN for the Perfect Join! Excel Magic Trick Short # 76 part 02
0:56
2025-04-18
106
Excel TEXTJOIN Function Trick to Join Text from 2 Columns into 1 Cell! Excel Short Magic Trick 76
1:20
2025-04-12
107
Opposite of TEXTJOIN? It's TEXTSPLIT used to Split Sub-text from Text String. Excel Short 76 Part 3
1:00
2025-04-19
108
Excel REPLACE function Beat FlashFill to Insert Dash into Description. Excel Magic Trick 1892
2:51
2025-06-08
109
Convert Proper Date to ISO YYYYMMDD Date. Excel Magic Trick 1895.
1:51
2025-06-18
110
Better Way to Convert ISO Date YYYYMMDD to Excel Date: TEXT Function Hack! Excel Magic Trick 1896
2:13
2025-06-19
111
COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901
24:46
2025-08-15
112
Excel TEXTSPLIT function to Split Values By Delimiter & More! Excel Magic Trick 1904
5:11
2025-09-09
113
Excel Power Query to Spilt Column of Delimited Values. Excel Magic Trick 1906
5:35
2025-09-11
114
Split Column of Values with TEXTSPLIT!? With TEXTJOIN’s Help Yes! Spill an Array of Arrays. EMT 1907
3:40
2025-09-12
115
The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908
7:43
2025-09-16
116
Complete Lesson in Excel Text Formulas that use References to Dates, Money & Arrays. EMT 1920.
7:47
2025-12-23
