Dueling Excel

Dueling Excel 102

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

Dueling Excel

Dueling Excel 101

Sum Numbers from Cells That Contain Both Text & Numbers DESCRIPTION See Mr Excel and excelisfun use two methods to add the numbers from cells that have both numbers and text. See these tricks: 1. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1224

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

Dueling Excel

Dueling Excel 73

Coax Time Value From Text: MOD, LEFT, RIGHT, TEXT, MOD Functions DESCRIPTION See Mr Excel and excelisfun use the functions MOD, LEFT, RIGHT, TEXT, TIMEVALUE, and MOD to coax a time value from a time [Read More >>>]

Excel Is Fun

Excel Magic Trick 1196

YYMMDD Text Dates To Serial Number Dates? 2 More Formulas & Other Tips… DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then [Read More >>>]

Excel Is Fun

Excel Magic Trick 1195

Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution? DESCRIPTION See how to deal with a Text Date in the form YYMMDD when some of the years are 1900 and some [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 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 >>>]