Excel Is Fun

Excel Magic Trick 1346

DESCRIPTION See how to use formulas to extract records from a Master Table to Sub Tables on Each Excel Worksheets for each product in the Master Table: (00:17) Introduction. Look at Dynamic End Result Solution. [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 30

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 [Read More >>>]

Dueling Excel

Dueling Excel 127

DESCRIPTION Adding After & Before Dash: Array Formula or VBA? See Mr Excel and excelisfun use two methods to solve this very difficult adding problem: you must add numbers from a column of text strings [Read More >>>]

Dueling Excel

Dueling Excel 107

Count Between Words DESCRIPTION See Mr Excel and excelisfun use three methods to add a leading zero at front and a dash in middle of a number that may be of variable length: 1. Formula [Read More >>>]

Excel Is Fun

Excel Magic Trick 1199

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 [Read More >>>]

Dueling Excel

Dueling Excel 67

Extract Initials From Full Name: VBA or Formula? DESCRIPTION See Mr Excel and excelisfun Extract Initials From Full Name using: VBA and a Formula. See the Functions TRIM, REPLACE, LEFT, and SEARCH. WORKBOOKS

Dueling Excel

Dueling Excel 51

Extract Dates from Cell With Dates and Words DESCRIPTION See Mr Excel and excelisfun Extract Dates from Cell With Dates and Words using two different methods. See the functions: DATEVALUE, RIGHT, IFERROR, LEN, TEXT, SEARCH, [Read More >>>]

Dueling Excel

Dueling Excel 018

DESCRIPTION See Mr Excel and excelisfun use the functions: IF, FIND, SEARCH, AND, OR, ISNUMBER, ISERROR, REPLCE and VLOOKUP. See Mr Excel and excel is fun create an IF function formula that use the functions [Read More >>>]

Excel Is Fun

Excel Magic Trick 1093

Extract Date from Middle of Description: Text To Columns or Formula? DESCRIPTION Extract Date from Middle of Description: Text To Columns or Formula: 1. Text To Columns 2. Formula that uses the functions SUBSTITUTE, REPLACE, [Read More >>>]