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 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 025

Extract Records NOT Swim or Ski (Filter or Formula?) DESCRIPTION See Mr Excel and excelisfun extract records from database that are NOT Swim or Ski with Filter, Advanced Filter, or Formula using ISNUMBER, LOOKUP and [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

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 1096

DESCRIPTION See how to extract date from middle of text string with a formula that uses SUBSTITUTE, SEARCH and MID functions. WORKBOOKS

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