Dueling Excel

Dueling Excel 57

Extract Many Years from Just Two Years DESCRIPTION See Mr Excel and excelisfun take the text string “1997-2000” and create a row of years consisting of 1997, 1998, 1999, 2000. See the functions LEFT, RIGHT, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1183

Remove All Text after Dash: Flash Fill, Text To Columns, Text Formula DESCRIPTION See how to take a list of menu items with unwanted text after the dash and remove the unwanted text using: (00:08) [Read More >>>]

Dueling Excel

Dueling Excel 045

+ or with Formula or Custom Number Formatting Math Plus or Minus DESCRIPTION See Mr Excel and excelisfun: 1) create a formula to extract a number from a text string that can be used for [Read More >>>]

Dueling Excel

Dueling Excel 041

VBA or Formula Extract Prefix for VLOOKUP DESCRIPTION See Mr Excel and excelisfun do VBA and an array formula to extract a varying length number prefix and then use that as the lookup_value for VLOOKUP. [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 30

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 creating labels. 4. Extract First Name formula using [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 19

DESCRIPTION Topics in this video: (00:11) Text Functions. (00:23) Partial Text Lookup: RIGHT & VLOOKUP. (02:17) Partial Text Lookup: LEFT and SEARCH & VLOOKUP. (05:56) Partial Text Lookup: MID & VLOOKUP. (07:51) Converting Numbers Stored [Read More >>>]

Excel Is Fun

Excel Magic Trick 1093

DESCRIPTION Extract Date from Middle of Description: Text To Columns or Formula: 1. Text To Columns 2. Formula that uses the functions SUBSTITUTE, REPLACE, SEARCH and LEFT WORKBOOKS