Beta

This is a new feature and we can’t wait to hear your feedback. Is it useful for your tasks? Is it easy to use? Just let us know via or . Use with caution: beta features may contain some bugs and rough edges. To test the feature, take a . or Use with caution: beta features may contain some bugs and rough edges. To test the feature, take a XLTools.

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.

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?