How to use XLTools functions in Excel

Functions make Excel a very powerful and flexible tool. It allows you to create the formulas just the way you need them. Excel has nearly 500 functions, and new ones are occasionally introduced. Sometimes, however, you may come across a situation, when there is no simple and ready-to-use function for your task.

XLTools Add-in offers additional functions that will improve your data processing efficiency. See the list of all supported functions below.

Before you begin, add Functions to Excel

Functions are one of the 20+ features within XLTools Add-in for Excel. Works in Excel 2019, 2016, 2013, 2010, desktop Office 365.

Get started with XLTools ribbon
Download XLTools for Excel
 – free trial gives you 14 days of full access to all features.

List of supported functions

This is the list of all supported XLTools functions. To learn how to apply a specific function, click on the link to the detailed guide in the table.

FunctionTypeDescription
XL.Random Array function Generates an array of random numbers, including unique random numbers
XL.DateAdd Date and time function Adds years, quarters, months, days, minutes, hours and seconds to a date
XL.DateToTicks Date and time function Сonverts date and time values into the number of ticks
XL.FindEmail Text function Finds and extracts an email address from a text string
XL.FindNumber Text function Finds and extracts a number from a text string
XL.FormatPhoneNumber Text function Formats a string as a phone number
XL.CountWords Text function Counts the number of words in a range
XL.Concatenate Text function Сoncatenates all values in a range into a single string with any separator
XL.StringFormat Text function Creates text strings with dynamically filled placeholders
XL.FormatDate Text function Сhanges format of date and time values
XL.ComputeMD5Hash Text function Encodes a text string to an MD5 hash
XL.HexColorToRGB Text function Converts Hex color code to RGB format
Any questions or suggestions?
illiamay u explain me how to translate text by XLTools
April 19, 2022 at 20:37
XI'd like to see functions to extract IP addresses and URL's
November 11, 2021 at 03:03
How can we help?