Microsoft Office Tutorials and References
In Depth Information
Managing data by using Flash Fill
Press Enter to accept the suggestions, even though some of them don’t include the
individual’s middle initial.
Edit the value in cell D3 so it reads Justin K. Harrison , and press Enter to have Flash
Fill update the name in cell D3 and the name in D4 .
On the tab bar, click the Addresses sheet tab to display the Addresses worksheet.
Select cells E2:F5 and then, on the Home tab, click the Number Format arrow. Then
click Tex t .
In cell F2 , enter 03214 , and then press Enter .
In cell F3 , start entering 07921 to have Flash Fill suggest values for the corrected
Press Enter to accept the suggested values.
Edit the value in cell F4 so it reads 98012 .
CLEAN UP Close the MailingNames workbook, saving your changes if you want to.