Additional SpeedTools V4 Functions

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

© 2001-2020 Decision Models  Legal Disclaimer Privacy Statement E-Mail Webmaster