Excel Forum
Similar Content
Basic Web Query in Excel - Import Data from the Web into Excel
Macro: Import data from the web into Excel with this macro. This is a basic web query macro that ...
Display The Actual Link / Email Address From Links in Excel - UDF
Macro: Display the actual link or email address from links within Excel with this UDF. This user ...
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...

Excel Magic Trick #104: National Debt Web Query

See how to run a web query to calculate the national debt that is incurred each hour. Lern how to use the Excel Functions:

The SUBSTITUITE function will remove parts of a text string and replace it with another text string (or nothing).
The VALUE function converts text to a number.
The MID function will extract a part of a text string from the middle of a text string
The FIND function tells you what the ordinal position a certain character is in a text string (FIND is case sensitive (SEARCH is not case sensitive).
The RIGHT function extracts text from a text string from the right

Got a Question? Ask it Here in the Forum.