Spreadsheet Assistant Functions
The following is a list of many of the new functions that the Spreadsheet Assistant adds to Microsoft Excel. You can use these in any formula that you need to write.
- Growth Rate Function
- Look For Text Function
- Number To Currency Function
- Date In Month Function
- Date To Day Function
- Extract A Word Function
- Contains Function
- Background Color Function
- Font Color Function Between XY Function
- File Exists Function
- File Name And Sheet Name Functions
- Insert In String Function
- Special Lookup Functions: High N Cells and Low N Cells
- Visible Cells Function
- Remove All Spaces Function
- Trim Left and Trim Right Functions
- User Name Function
- Last Cell In Column and Last Cell In Row Functions
- Fixed Length Function