|
Featured Tutorial
Featured Macro
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
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