Excel Is Fun

Highline Excel 2016 Class 18

DESCRIPTION In this video learn about: (00:13) Introduction (01:08) Find & Replace feature (Clean Data) (03:49) Flash Fill: Clean Data (10 Examples) (11:14) Text To Columns (TTC) (12:16) Text To Columns (TTC) to split data [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 08

DESCRIPTION In this video learn about: (00:12) Introduction (00:46) Text Formulas: Ampersand to Join Items together (01:38) Text Functions to extract partial text items from a larger text item. (02:57) Extract State with LEFT function [Read More >>>]

Excel Is Fun

Excel Magic Trick 1289

DESCRIPTION Why Doesn’t =ROW(1:LEN(A1)) Work? Learn 6 methods to remove “USD” from a column of values such as $ 1.23 USD, $ 56.34 USD, etc. that resulted from multiple downloaded CSV Files, including Replace feature, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1288

DESCRIPTION Why Doesn’t =ROW(1:LEN(A1)) Work? Learn the formula =ROW(1:LEN(A1)) does not work. See that the INDIRECT Function comes to the rescue to create a formula that does work: =ROW(INDIRECT(“1:”&LEN(A1))) Work. Alos learn about the robust [Read More >>>]

Excel Is Fun

Excel Magic Trick 1277

DESCRIPTION Learn how to to Sort Logical Values Alphabetically: false, FALSE, False, true, TRUE, True, and mixed single word text. See how using a space at the end of text will work, but will cause [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 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 >>>]

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