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 all the work done for you.

Add characters, remove strings, split cells, extract text, trim spaces, convert symbols, change case, count chars and swap text — the tool lets you do all this quickly and accurately. Feel free to use in Excel for Mac as well as in Excel for Windows and Excel 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

These companies choose Ablebits products

Choose your subscription plan

Current version - Beta 1, 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

  • 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

Browsers

  • Google Chrome 78 and higher
  • Microsoft Edge 44 and higher
  • Microsoft Edge (Chromium-based)
    beta support 79 and higher
  • Safari 12 and higher (limited support)
  • Firefox 69 and higher

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close