Flash Fill is a new tool in Excel 2013 and higher that will make your life much easier. If you have a lower version of Excel, see what it can do anyway. It is a good idea to upgrade!
Flash Fill allows you to show Excel what you want to happen, and Excel will try and identify a pattern and replicate it. So do you need to combine the first name, middle initial and surname of your staff. Flash Fill makes this easy.
To see the full course contents click here.