Microsoft Office Tutorials and References
In Depth Information
Syntax
Figure 12.46.
Figure 12.46. Excel does not display the complete set of results.
Excel does not display the complete set of results.
77. To get a full view of what you are dealing with, copy cell C7. Open
Notepad and paste the text into Notepad. You can now see the complete
result of the query (see Figure 12.47 ) . In this figure, you can make out
elements of the results. A field called Name indicates that the
author was pampopperchng. A field called Published indicates
2012-09-04 with a time. A field called Title has the actual tweet,
which in this case is RT @SimonMerrett: #ExcelExpert: Use =vlookup
to populate fields eg name and address by using customer number.
Search JabSto ::




Custom Search