Do you ever get a spreadsheet with the data not quite the way you need it? Maybe you have a first name and last name in separate cells but you need the Full name. What about the opposite problem of a full name cell that you want to separate into first and last name cells?
This 3 1/2 minute video will explain how to use Flash Fill to get your data the way you need it.
