Microsoft Office Tutorials and References
In Depth Information
Managing data by using Flash Fill
3
Press Enter to accept the suggestions, even though some of them don’t include the
individual’s middle initial.
4
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 .
2
5
On the tab bar, click the Addresses sheet tab to display the Addresses worksheet.
6
Select cells E2:F5 and then, on the Home tab, click the Number Format arrow. Then
click Tex t .
7
In cell F2 , enter 03214 , and then press Enter .
8
In cell F3 , start entering 07921 to have Flash Fill suggest values for the corrected
series.
9
Press Enter to accept the suggested values.
10
Edit the value in cell F4 so it reads 98012 .
CLEAN UP Close the MailingNames workbook, saving your changes if you want to.
Search JabSto ::




Custom Search