Excel Is Fun

Excel Magic Trick 1289

April 20, 2017 0

DESCRIPTION Why Doesn’t =ROW(1:LEN(A1)) Work? Learn 6 methods to remove “USD” from a column of values such as $ 1.23 USD, $ 56.34 USD, etc. that resulted from multiple downloaded CSV Files, including Replace feature, […]

Excel Is Fun

Highline Excel 2013 Class Video 30

April 7, 2017 0

Custom Number Formatting & Text Functions, (33 Examples) DESCRIPTION Topics in this video: 1. 23 Examples of Custom Number Formatting. 2. Custom Number Formatting For Unit Price for Invoice. 3. Three TEXT function examples for […]

Dueling Excel

Dueling Excel 135

March 29, 2017 0

DESCRIPTION From Text to Math: VBA or Excel 4 Macro Function: EVALUATION See Mr Excel and excelisfun use two methods to convert a text string to a match expression that can calculate the correct answer: […]

Dueling Excel

Dueling Excel 102

September 14, 2016 0

Remove Duplicate Records Based On Partial Text in a Cell DESCRIPTION See Mr Excel and excelisfun use two methods to Remove Duplicate Records Based On Partial Text in a Cell using: 1. Formula with SUBSTITUTE, […]

Excel Is Fun

Excel Magic Trick 1224

August 25, 2016 0

Which Similar Array Formula? Compare Number of Array Operations DESCRIPTION Learn how to build similar formulas and compare the number of array operations in order to decide which formula might be most efficient: (00:08) Problem […]

Excel Is Fun

Excel Magic Trick 1222

August 18, 2016 0

Formula To Add 10kg, 6kg, 19kg: Array Formula Or Custom Number Format? DESCRIPTION Learn how to Create a Formula to Add Column Filled With Weights Like: 10kg, 33kg, 19kg: (00:10) Problem Setup (01:12) Customer Number […]

Dueling Excel

Dueling Excel 94

August 17, 2016 0

Lookup Data In Text String & Extract Data From Text String DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Lookup Data In Text String & Extract Data From Text String in order […]

Excel Is Fun

Excel Magic Trick 1199

April 4, 2016 0

Formula to Extract Everything After Last Space: Two Formula Solutions DESCRIPTION See how to use Formula to Extract Everything After Last Space: (00:08) Problem Setup (01:05) Formula with TRIM, RIGHT, SUBSTITUTE, REPT, LEN and LEN […]

Dueling Excel

Dueling Excel 61

January 27, 2016 0

Formula To Report Cell Reference 5 Examples DESCRIPTION See Mr Excel and excelisfun create five formulas that can retrieve a cell reference. See the functions: MATCH, ROW, ADDRESS, COLUMN, CELL, and SUBSTITUTE, and the Ampersand […]