One of the newest Excel text functions that can save you time is Flash Fill, which combines text data without needing to create a formula.
When you type Excel text in a cell that combines text from different columns – for example, a person's first name that's in one…