Or say you have information in Excel that isn’t formatted the way you need it to be, such as this list of names. And going through the entire list manually to correct them is daunting. Here, Flash Fill can help.
Type the first name the way you want it.
Start to type the next name, and Excel provides a preview of the names formatted the way you want.
Press Enter, and Flash Fill fills in the names for you.