Excel tasks WITHOUT using formulas

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=UYsIkZd7XA0

00:00 Split a combined name into separate columns (first name and surname)- no formula Excel • 00:34 Split text into 3 columns with no formula ( what to do if Flash Fill gets it wrong) • 01:30 Combine 2 columns into 1 in Excel without using formula • 01:45 Flash Fill not finding a pattern- give another example • 02:14 Combine cells but in reverse order without using Excel formulas • 03:08 Correct text so that it is seen as a number without using Excel formulas • 03:35 Pull a name out of text which contains letters and numbers WITHOUT Excel formula • 03:52 Pull a number WITH leading zeros out of an Excel cell without formula • 04:06 Split a column of text by a variable delimiter WITHOUT formula • Using Excel's Flash Fill to perform various common Excel tasks which would normally require Excel formula/ functions or use of multiple of the tools in Excel. Very useful for once off cleaning tasks in Excel.

#############################

New on site