Text Toolkit for Excel

Make your text cells perfect

If you work with text in Excel a lot, Text Toolkit will be a real game changer. Instead of building formulas or performing multi-step operations, you start the add-in, pick the option, and get the job done.

Add characters, remove strings, split cells, extract text, trim spaces, convert symbols, change case, count chars, swap text, merge cells, combine rows, and work with regular expressions to find, extract, remove, or replace matching strings — the tool will do all this quickly and accurately for you. Feel free to use Text Toolkit in Excel for Mac,
for Windows, and on the web.

Get it for free
Text Toolkit for Excel

Discover 35+ handy options for your Excel text

Append text to the selected cells
  • Add text to the beginning or end of your Excel cells
  • Append text before or after certain characters in the selected range
  • Insert text after the specified number of characters from the beginning or end of cells
Samples:
  • ABC → xyzABC
  • ABC → AxyzBC
  • ABC → ABxyzC
  • ABC → ABCxyz
Add text
Remove text
Delete chars, strings, numbers, etc.
  • Remove the specified characters or strings
  • Delete all non-printing, text, numeric chars, punctuation, or symbols
Samples:
  • ABCxyz → ABC
  • ABC123 → ABC
  • ABC!!! → ABC
Convert text to the needed case
  • Change all words in a cell to UPPER case
  • Get all text in your cells changed to lower case
  • Capitalize Each Word And Change Other Letters To Lowercase
  • Capitalize the first letter of the first word in each sentence in your cells
Samples:
  • ABC xyz → ABC XYZ
  • ABC xyz → abc xyz
  • ABC xyz → Abc Xyz
  • ABC xyz → Abc xyz
Change case
Convert text
Replace characters with other symbols
  • Change digits formatted as text to number format and remove spaces or leading apostrophes
  • Replace the selected characters with other symbols
  • Convert accented characters to their non-accented equivalents
Samples:
  • ABC → ABxyz
  • Áçè → Ace
Extract text or numbers
  • Extract all numbers in a cell
  • Extract a certain quantity of the first or last characters
  • Extract text by its position in a cell
  • Get all text before or after certain characters extracted
  • Paste the result as a formula
Samples:
  • ABCxyz → xyz
  • ABCxyz → ABC
  • ABC123 → 123
Extract text
Remove by position
Delete text by its position
  • Delete a certain number of the first or last characters in the selected cells
  • Remove all text before or after the indicated characters
Samples:
  • ABCxyz → ABC
  • ABCxyz → xyz
Split cells by chars, strings, or mask
  • Split your cells by certain strings
  • Divide text by the selected characters
  • Split the selected cells by the indicated mask
Samples:
  • ABC xyz → ABC | xyz
  • ABCxyz → A | C | yz
Split text
Count characters
Count all or specific chars and words
  • Count all characters
  • Count the specified characters
  • Count all words
  • Insert the result as a formula
Samples:
  • ABC xyz → 1 (A char)
  • ABC xyz → 6 (chars)
  • ABC xyz → 2 (words)
Eliminate leading zeros, excess and non-breaking spaces
  • Remove all excess zeros before cell values
  • Delete spaces before and after cell values
  • Trim excess spaces between words
  • Remove non-breaking spaces
Samples:
  • 000ABC → ABC
  •    ABC → ABC
  • A B  C → A B C
Trim spaces
Swap text
Swap text in your cells
  • Switch text around within one cell by the chosen separator
  • Select the number of the separator occurrence from the beginning or from the end
Samples:
  • ABC xyz → xyz ABC
Match, extract, remove, and replace values using regular expressions
  • Use regular expressions to find strings that fit a specified pattern
  • Copy matching strings into the right adjacent column
  • Delete matches
  • Substitute matching strings with any other you need
Samples:
Match \w{3}\s+\d{3}
Regex Tools Sample Match
Extract \d+
Regex Tools Sample Extract
Remove [^\d]+
Regex Tools Sample Remove
Replace [A-Za-z]+ with ***
Regex Tools Sample Replace
Regex Tools
Merge Cells
Combine and merge cells
  • Concatenate text cells horizontally or vertically
  • Summarize column by column or row by row
  • Join all selected values into one cell
  • Use single- or multiple-character delimiters
  • Aggregate using SUM, AVERAGE, COUNT, COUNTA, MAX, or MIN
Samples:
Merge Cells Sample 1
Merge Cells Sample 2
Merge Cells Sample 3
Merge rows by duplicate values
  • Dedupe key columns, merge selected ones, and keep the top row for the rest
  • Find and remove duplicates in key columns
  • Combine strings or summarize numbers by key columns
  • Use delimiters or aggregate functions
  • Sort merged strings
Samples:
Dedupe A, merge B, and keep the first row of data for C
Combine Rows Sample 1
Dedupe A, sum B, and keep the first row of data for C
Combine Rows Sample 2
Dedupe A, sum B, and keep the last row of data for C
Combine Rows Sample 3
Combine Rows Img 1
Combine Rows Img 2

Choose your subscription plan

Current version - Beta, Stable


Beta
Client apps per user

You can have several client apps on one device, e.g. Excel Online in your Chrome and desktop Excel can be connected simultaneously and are treated as two separate client apps.

4
Technical support service

Our support team is always eager to help you via email, live chat, or phone.

Subscription duration Unlimited
License quantity 1 user
Pricing Free during beta testing
  Get it from

System requirements

Microsoft Excel IconMicrosoft Excel
  • Excel for Windows connected to Office 365
  • Excel for Mac connected to Office 365
  • Excel for Windows 2019
  • Excel for Windows 2016
  • Excel for Mac 2019
  • Excel for Mac 2016 starting from 16.24
  • Excel on the web
Google Chrome IconBrowsers
  • Google Chrome 78 and higher
  • Microsoft Edge (Chromium-based)
    beta support 79 and higher
  • Safari 12 and higher (limited support)
  • Firefox 69 and higher