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 2024, 2019, 2016, 2013, 2010, and Microsoft 365.
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.
| Function | Type | Description |
|---|---|---|
| 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 |
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
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!
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!