Dueling Excel

Dueling Excel 145

June 7, 2017 0

DESCRIPTION See Mr Excel and excelisfun convert YYYYMMDD Numbers To Dates: 1. Text To Columns 2. Formula with DATE, LEFT, RIGHT, MID functions 3. Flash Fill 4. Text Function with custom Number Format 0000\/00\/00 WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 31

April 14, 2017 0

Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More DESCRIPTION Topics in this video: 1. TODAY function to put in today’s date so that it updates each day. 2. NOW to put in today’s date […]

Dueling Excel

Dueling Excel 116

October 26, 2016 0

Extract Individual Letters From Cell and do Lookup Adding, then… DESCRIPTION See Mr Excel and excelisfun use two methods to do lookup adding from a cell and then show one of three categories: ‘Under Zero”, […]

Dueling Excel

Dueling Excel 107

September 23, 2016 0

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 […]

Dueling Excel

Dueling Excel 98

August 31, 2016 0

Extract & Lookup Number When Table Of Numbers Is In A Single Cell DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Check whether Numbers In Cell C2 Also In F2? 2. Mr […]

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 1196

March 14, 2016 0

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 […]

Excel Is Fun

Excel Magic Trick 1195

March 7, 2016 0

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 […]

Dueling Excel

Dueling Excel 045

October 14, 2015 0

+ 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 […]