XPlus

Description

XPlus is an Excel Function library that adds over 100 functions to Excel, making it much easier to do common tasks within Excel. XPlus is written purely in VBA and has no external dependencies, making it very easy to install and incorporate into an Excel Workbook. Additionally, since XPlus is MIT Licensed, and thus has very little restrictions on use, it can be used commercially and personally free and charge, and can be shipped to others within an Excel Workbook free of charge. This means that even if another user doesn't have XPlus installed, they can still use XPlus when you send your workbook to them.

Documentation

Official documentation for XPlus can be found here. The official documentation gives in-depth explanations and examples of the functions and XPlus, and the function list below should be used primarily as a reference only.

Function List

Below is a list of all functions within XPlus:

• Validators

  • IS_EMAIL
  • IS_PHONE
  • IS_CREDIT_CARD
  • IS_URL
  • IS_IP_FOUR
  • IS_MAC_ADDRESS
  • CREDIT_CARD_NAME
  • FORMAT_FRACTION
  • FORMAT_PHONE
  • FORMAT_CREDIT_CARD
  • FORMAT_FORMULA

• Utilities

  • DISPLAY_TEXT
  • JSONIFY
  • UUID_FOUR
  • HIDDEN
  • ISERRORALL
  • COUNTERRORALL
  • JAVASCRIPT
  • SUMSHEET
  • AVERAGESHEET
  • MAXSHEET
  • MINSHEET
  • HTML_TABLEIFY
  • HTML_ESCAPE
  • HTML_UNESCAPE
  • SPEAK_TEXT
  • EVALUATE_FORMULA
  • ISBADERROR
  • REFERENCE_EXISTS
  • ADDIN_EXISTS
  • ADDIN_INSTALLED

• StringMetrics

  • HAMMING
  • LEVENSHTEIN
  • LEV_STR
  • LEV_STR_OPT
  • DAMERAU
  • DAM_STR
  • DAM_STR_OPT
  • PARTIAL_LOOKUP

• StringManipulation

  • CAPITALIZE
  • LEFT_FIND
  • RIGHT_FIND
  • LEFT_SEARCH
  • RIGHT_SEARCH
  • SUBSTR
  • SUBSTR_FIND
  • SUBSTR_SEARCH
  • REPEAT
  • FORMATTER
  • ZFILL
  • SPLIT_TEXT
  • COUNT_WORDS
  • CAMEL_CASE
  • KEBAB_CASE
  • REMOVE_CHARACTERS
  • COMPANY_CASE
  • REVERSE_TEXT
  • REVERSE_WORDS
  • INDENT
  • DEDENT
  • SHORTEN
  • INSPLIT
  • ELITE_CASE
  • SCRAMBLE_CASE
  • LEFT_SPLIT
  • RIGHT_SPLIT
  • SUBSTITUTE_ALL
  • INSTRING
  • TRIM_CHAR
  • TRIM_LEFT
  • TRIM_RIGHT
  • COUNT_UPPERCASE_CHARACTERS
  • COUNT_LOWERCASE_CHARACTERS

• Regex

  • REGEX_SEARCH
  • REGEX_TEST
  • REGEX_REPLACE

• Range

  • FIRST_UNIQUE
  • COUNT_UNIQUE
  • SORT_RANGE
  • REVERSE_RANGE
  • COLUMNIFY
  • ROWIFY
  • SUMN
  • AVERAGEN
  • MAXN
  • MINN
  • SUMHIGH
  • SUMLOW
  • AVERAGEHIGH
  • AVERAGELOW
  • INRANGE
  • COUNT_UNIQUE_COLORS
  • ALTERNATE_COLUMNS
  • ALTERNATE_ROWS

• Random

  • RANDOM_SAMPLE
  • RANDOM_RANGE
  • RANDOM_SAMPLE_PERCENT
  • RANDBOOL
  • RANDBETWEENS

• Properties

  • RANGE_COMMENT
  • RANGE_HYPERLINK
  • RANGE_NUMBER_FORMAT
  • RANGE_FONT
  • RANGE_NAME
  • RANGE_WIDTH
  • RANGE_HEIGHT
  • RANGE_COLOR
  • SHEET_NAME
  • SHEET_CODE_NAME
  • SHEET_TYPE
  • WORKBOOK_TITLE
  • WORKBOOK_SUBJECT
  • WORKBOOK_AUTHOR
  • WORKBOOK_MANAGER
  • [WORKBOOK_COMPANY](https://x-vba.com/xplus/prope