Quick, clean, and to the point

Flash fill

Windows shortcut 

In a new column next to existing data, enter a value that represents what you want to extract, combine, etc. Then, in the cell below, use this shortcut. Excel will try to apply the same pattern to all rows in the data. You can use Flash Fill with text, numbers, and dates.

Flash fill is a new feature added in Excel 2013 (but sadly not available in Excel 2016 for Mac, or any other Mac version)

That worked like a charm! Thank you so much, your website is the best thing I have come across in a while! -Shawna
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course