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.

Get started with XLTools ribbon
– 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
Peter LiapinIn older versions of XLTools, translating text wasn't possible. Now, with our new GPT.Translate function, it's easy! Basic Translation: Translate text directly within Excel: =GPT.Translate("Hello, how are you?", "Spanish") Output: Hola, ¿cómo estás? Translate Text in Multiple Cells: You can use cell references to translate multiple cells at once: =GPT.Translate(B2:B4, "French") Input Data
AB
"Greeting 1""Good morning, everyone!"
"Greeting 2""Welcome to the event."
"Greeting 3""Enjoy your day at the fair!"
Output: Bonjour tout le monde!, Bienvenue à l'événement., Profitez de votre journée à la foire! Specify Source Language: You can also specify the source language for more accurate translations: =GPT.Translate("Bonjour tout le monde!", "English", "French") Output: Hello everyone! Check out the full guide on how to use GPT.Translate to improve your Excel workflows. Let us know if you need further assistance!
May 9, 2024 at 08:47
XI'd like to see functions to extract IP addresses and URL's
November 11, 2021 at 03:03
Peter LiapinThanks for your suggestion! I am glad to let you know that we have recently released new GPT functions which you can use to easily extract IP addresses and URLs. Extracting IP Addresses: Use the GPT.Extract function to find all IP addresses in the given text: =GPT.Extract("Here are the server logs: 192.168.0.1, 10.0.0.2, and 172.16.0.3.", "ip addresses") Output: 192.168.0.1, 10.0.0.2, 172.16.0.3 To get just the first IP address: =GPT.Extract("Server logs: 192.168.0.1, 10.0.0.2, and 172.16.0.3.", "first ip address") Output: 192.168.0.1 Extracting URLs: Find all URLs in the text: =GPT.Extract("Check out these resources: https://example.com/docs, http://example.org, and https://sub.example.net/page.", "urls") Output: https://example.com/docs, http://example.org, https://sub.example.net/page To get the first URL: =GPT.Extract("Visit https://example.com/docs, http://example.org, and https://sub.example.net/page.", "first url") Output: https://example.com/docs You can also use cell references to extract URLs from multiple cells at once: =GPT.Extract(B2:B4, "urls") Find out more about GPT functions and how to use them in our guide. Let us know if you have any more suggestions!
May 9, 2024 at 08:34
How can we help?