Microsoft Office Tutorials and References
In Depth Information
Tip 65: Using Flash Fill to Combine Data
Figure 65-2 shows another example. Column A:D hold the original data, and the text in column E was
filled in using Flash Fill, after providing two examples. The equivalent formula to generate the text in
column E is
=A4&” “&B4&”: “&TEXT(D4,”$0”)&” due on 10/”&C4&”/2013”
Figure 65-2: Flash Fill generated the text in column E.
Search JabSto ::




Custom Search