Flash Fill allows you to show Excel what you want to happen, and Excel will try and identify a pattern and replicate it.
In this lesson you will learn how to (quickly) convert names that have had their spaces removed into proper name and surname with minimal effort.
To see the full course contents click here.