SpeedTools V4 Functions for Text and Math
Text Functions
- Extracts groups of characters or digits from a Text-string - GROUPS
- Concatenate cell values to a string using delimiters - CONCAT.RANGE
- Expand/Contract text-strings to a fixed length - PAD.TEXT
- Reverse the characters in a Text-string - REVERSE.TEXT
- Splits text into tokens using delimiters - SPLIT.TEXT
- Find the position of a RegEx pattern within a text-string - Rgx.FIND
- Finds the length of the substring that matches a RegEx pattern - Rgx.LEN
- Replaces substring(s) that match RegEx patterns - Rgx.SUBSTITUTE
- Extracts substrings that match regular expressions - Rgx.MID
- Wildcard pattern testing for text strings - ISLIKE
- Regular expression pattern testing for text strings - Rgx.ISLIKE
Math Functions
- Fast 2-dimensional linear interpolation - LINTERP2D
- Fast linear interpolation in a vertical table - VLINTERP2
- Fast calculation of the Gini inequality coefficient - GINICOEFF
Try it out for yourself:
Download FastExcel V4.
Get a 15-day full-featured trial license
You can convert the trial version of FastExcel V4 to a fully licensed version at any time by purchasing one of the FastExcel V4 licensing options.
Want to know more?
View the FastExcel V4 WebHelp
|
