### Highline Excel 2013 Class Video 39

June 9, 2017

DESCRIPTION Topics in this video: 1. Import Commas Delimited Data From Word Document with Copy and Paste then do Text To Columns. 2. Import CSV File and Txt File. 3. Import Proper Data Set into […]

### Dueling Excel 145

June 7, 2017

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

### Highline Excel 2013 Class Video 38

June 2, 2017

DESCRIPTION Topics in this video: 1. Split Text with Delimiter = Space. Split First and Last Name and Skip a column. Text To Columns keyboard: Alt, A, E or Alt, D, E. 2. Split Text […]

### Excel Magic Trick 1289

April 20, 2017

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

### Highline Excel 2013 Class Video 27

March 17, 2017

DESCRIPTION Topics in this video: 1. List of possible errors in Excel. 2. 4 Steps to finding formula errors. 3. 3 Examples of how to use the 4 steps. 4. Cleaning Text data with the […]

### Excel Magic Trick 1113

March 11, 2015

DESCRIPTION 1. Text To Columns using Fixed Width, One Time Event 2. Formula that will update when data changes. Formula uses MID and COLUMNS functions and Mixed Cell References. WORKBOOKS

### Excel Magic Trick 1112

March 10, 2015

DESCRIPTION (01:06) Group By Date In PivotTable Error (Cannot group that selection error) (01:42) Text To Columns To Convert Text Dates To Dates (02:53) Text To Columns Fatal Error (Microsoft Excel has stopped working error) […]

### Excel Magic Trick 1093

January 22, 2015

Extract Date from Middle of Description: Text To Columns or Formula? DESCRIPTION Extract Date from Middle of Description: Text To Columns or Formula: 1. Text To Columns 2. Formula that uses the functions SUBSTITUTE, REPLACE, […]