Converts the text in all selected cells to Proper Case (first letter of each word capitalized).

Converts the text in all selected cells to UPPER CASE.

Converts the text in all selected cells to lower case.

Converts the text in all selected cells to Sentence case (first letter capitalized, the rest lowercase).

Removes extra spaces from selected cells, including leading, trailing, and multiple spaces between words.

• Add to beginning - Adds a specified string to the start of the text in all selected cells.
• Add to end - Adds a specified string to the end of the text in all selected cells.
• Add to middle - Inserts a specified string into the middle of the text in all selected cells, based on a user-defined position.

• Remove from beginning - Removes a specified substring from the start of the text in all selected cells.
• Remove from end - Removes a specified substring from the end of the text in all selected cells.
• Remove from middle - Removes a specified substring from the middle of the text in all selected cells, based on a user-defined position.

• Left - Extracts a specified number of characters from the start of the text in all selected cells.
• Right - Extracts a specified number of characters from the end of the text in all selected cells.
• Mid - Extracts a specified number of characters from the middle of the text in all selected cells, based on a user-defined starting position.

Removes all non-letter and non-number characters from the text in selected cells. Only A-Z, a-z, and 0-9 are preserved.

Removes all non-letter characters from the text in selected cells. Only alphabetic characters Only A-Z and a-z are preserved.

Reverses the entire text in each selected cell (character by character).
Example: "Hello" → "olleH"

Reverses the order of words in each selected cell while keeping the words themselves intact.
Example: "Hello world again" → "again world Hello"

• Serbia - Formats numeric values in selected cells to Serbia phone number style: 060/12-34-567.
• USA - Formats numeric values in selected cells to U.S. phone number style: (123) 456-7890.

Converts text in selected cells from Latin script to Cyrillic script.

Converts text in selected cells from Cyrillic script to Latin script.

Calculates and displays all the factors (divisors) of the specified number.

Change the value of all selected cells by a specified percentage.
Enter a positive number to increase the values or a negative number to decrease the values by the specified percentage

Rounds all numbers in the selected cells to 2 decimal places.

Rounds numbers in selected cells to the nearest multiple of a custom value entered by the user.
(e.g., entering 1000 rounds values to the nearest thousand.)

For a selected range, calculates the sum of every possible combination of a specified number of cells.
Results are inserted as formulas, showing which values are being summed.

Creates an interactive world map where users can enter values for each country and color-code the map based on those values.
See linked video for a full walkthrough.

Creates an interactive map of Europe where users can enter values for each country and color-code the map based on those values.
See linked video for a full walkthrough.

Creates an interactive map of Bosnia and Herzegovina where users can enter values for each region and color-code the map based on those values.
See linked video for a full walkthrough.

Creates an interactive map of Croatia where users can enter values for each region and color-code the map based on those values.
See linked video for a full walkthrough.

Creates an interactive map of Montenegro where users can enter values for each region and color-code the map based on those values.
See linked video for a full walkthrough.

Creates an interactive map of North Macedonia where users can enter values for each region and color-code the map based on those values.
See linked video for a full walkthrough.

Creates an interactive map of Serbia where users can enter values for each region and color-code the map based on those values.
See linked video for a full walkthrough.

Creates an interactive map of Serbia where users can enter values for each municipality and color-code the map based on those values.
See linked video for a full walkthrough.

Creates an interactive map of Slovenia where users can enter values for each region and color-code the map based on those values.
See linked video for a full walkthrough.

Selects a custom range based on a starting cell, and the number of rows and columns specified by the user.

Expands or reduces the current selection by a specified number of rows and/or columns.
Use negative numbers (e.g., -2) to reduce the selection.

Removes specified cells from the current selection.
(Useful for older Excel versions that don't support manual deselection.)

Generates all possible combinations of values from the selected range, excluding combinations where a value is paired with itself.

Generates all possible combinations of values from the selected range, including combinations where a value is paired with itself.

Swaps the contents of two ranges.

Flips the order of rows within the selected range. The top row becomes the bottom row, the second row becomes the second-to-last, and so on.

Flips the order of columns within the selected range. The leftmost column becomes the rightmost, and so on.

Filters cells based on a selected range. Choose whether to keep only the cells within the range or exclude them from the selection.

Compares two ranges and lists: values that appear only in the first, values that appear only in the second and values that appear in both but different number of times.

Highlights duplicate values between two selected ranges by changing the cell background color.

Highlights duplicates between two selected ranges using conditional formatting, making it dynamic and update-friendly.

Checks whether all values in the selected range are unique, and displays a message with the result.

Converts columns to rows by unpivoting the selected data — useful for transforming tabular data into a normalized format.
(See linked video for a full walkthrough.)

Randomly shuffles the values of all cells within the selected range, without changing the structure.

Randomly rearranges rows within the selected range.

Randomly rearranges columns within the selected range.

Deletes all completely empty sheets in the current workbook.

Deletes all entirely empty rows from the selected range.

Deletes all entirely empty columns from the selected range.

Fills the selected cells with random values from a specified range.

Populates each selected cell with a random letter from the Latin alphabet.

Populates each selected cell with a random letter from the Cyrillic alphabet.

Toggles the visibility of page breaks in the worksheet.

Enables or disables reading mode, which highlights the row and column of the currently selected cell for better focus.

Selects all cells in the worksheet that have the same fill color as the reference cell.

Replaces multiple values at once.
• Replace many values with the same value
• Or provide value pairs for targeted replacements

Selects all numeric cells that meet a condition.

Inserts and fits a picture perfectly into the selected cell range.

Manually checks if a new version of the add-in is available.

Counts how many times a substring appears in a text.

=COUNTTEXT(text, substring)
text - The text to search within.
substring - The substring to count.

Counts the number of words in a text.

=COUNTWORDS(text)
text - The text to count words in.

Converts the text from Cyrillic to Latin script.

=CYRILLICTOLATIN(text)
text - Text to convert from Cyrillic to Latin.

Removes all characters in a string after the first occurrence of a specified substring.

=DELETEAFTER(text, substring)
text - The original text.
substring - The substring after which all content will be deleted.

Removes all characters in a string before the first occurrence of a specified substring.

=DELETEBEFORE(text, substring)
text - The original text.
substring - The substring before which all content will be deleted.

Converts the text from Latin to Cyrillic script.

=CYRILLICTOLATIN(text)
text - Text to convert from Latin to Cyrillic.

Converts a number into words in the either English or Serbian.

=NUMBERTOTEXT(number, language)
number - The numeric value to convert.
language - The language to use. "en" for English or "srb" for Serbian.

Removes all specified characters from the text.

=REMOVECHARS(text, characters)
text - The string to clean.
characters - A string containing all characters to remove from the text.

Checks whether the text contains the specified substring.

=STRINGMATCH(text, substring)
text - The text to search within.
substring - The substring to search for.

Extracts substring from the text based on starting and ending delimiters.

=TEXTBETWEEN(text, starting_delimiter, ending_delimiter)
text - The original text.
starting_delimiter - The text that marks the beginning of the substring to extract.
ending_delimiter - The text that marks the end of the substring to extract.

Counts how many cells in a range have the same background or font color as a specified cell.

=COUNTBYCOLOR(range, color_cell, [mode])
count_range - The range of cells to check.
color_cell - A cell whose color will be used.
mode [Optional] - 0 to use background color, 1 to use font color, 2 to use both. Default is 0.

Counts how many unique values exist in a given range.

=COUNTUNIQUE(range)
range - The range of cells to analyze.

Checks if the specified number is prime.

=ISPRIME(number)
number - The number to test.

Calculates the percentage change from an old value to a new one.

=PERCENTCHANGE(old_value, new_value)
old_value - The initial value.
new_value - The new value to compare.

Returns a dynamic array of all prime numbers up to the specified number.

=PRIMEARRAY(number)
start_number - The number from which we want prime numbers. end_number - The number to which we want prime numbers.

Sums all cells in a range that have the same background or font color as the specified cell.

=SUMBYCOLOR(range, color_cell, [mode])
sum_range - The range of cells to sum.
color_cell - A cell whose color will be used.
mode [Optional] - 0 to use background color, 1 to use font color or 2 to use both. Default is 0.

Calculates the sum of all digits in a number.

=SUMDIGITS(number)
number - The number whose digits will be summed.

Calculates the weighted average of a list of numbers.

=WEIGHTEDAVERAGE(values, weights)
values - The range or array of values.
weights - The corresponding weights for each value.

Returns a random city from the specified country.

=RANDOMCITY(country)
country - The name of the country to pick a city from.

Returns a random country

=RANDOMCOUTRY([continent])
continent [Optional] - The continent to choose a country from. If omitted, it generates a random country from anywhere.

Generates a random date between two dates.

=RANDOMDATE(start_date, end_date)
start_date - Lower bound of the date range.
end_date - Upper bound of the date range.

Generates a random email address.

=RANDOMEMAIL(first_name, last_name)
first_name - First name to be used to the random email.
last_name - Last name to be used to the random email.

Returns a random first name based on language and gender.

=RANDOMFIRSTNAME(language, gender)
language - Either "srb" for Serbian or "en" for English.
gender - Either "m" for male names, "f" for female names or "all" for both.

Returns a random full name, based on language and optionally gender.

=RANDOMFULLNAME(language, gender)
language - Either "srb" for Serbian or "en" for English.
gender - Either "m" for male names, "f" for female names or "all" for both.

Returns a random last name based on language.

=RANDOMLASTNAME(language)
language - Either "srb" for Serbian or "en" for English.

Generates a random string based on a pattern using criteria characters.

=RANDOMPATTERN(pattern)
pattern - Pattern to be used to generate a random string.

Pattern symbols:
A = uppercase letter
a = lowercase letter
0 = digit
* = special character

You can escape any placeholder with "\" to keep it literal.
Examples: Pattern "AAaa0**" might generate "GJom6!_"
Pattern "\A\A\A--AAA" might generate "AAA--KLQ"

Randomly picks one value from the provided range.

=RANDOMPICK(range)
range - A range of cells from which one value will be randomly selected.

Converts a number from one numeral base to another.

=BASECONVERT(value, from_base, to_base)
value - The number to convert.
from_base - The current base of the value (e.g., 10 for decimal, 16 for hex).
to_base - The base to convert the value into.

Calculates the difference between two dates in the specified units.

=DATEDIFFUNITS(first_date, second_date, unit)
first_date - The first date.
second_date - The second date.
unit - The unit of measurement: "days", "months", or "years".

Returns the current exchange rate between two currencies.

=EXCHANGERATE(from_currency, to_currency)
from_currency - The three-letter code of the original currency.
to_currency - The three-letter code of the target currency.
You need internet connection for this function to work.

Exchange rate data is provided by the open-source project fawazahmed0/exchange-api, released under the CC0 1.0 Universal license.