Cell Cleaner for Microsoft Excel

Delete excess spaces and characters in Excel 2016, 2013 - 2007, change case, split cells and more

With Cell Cleaner for Excel you can quickly and easily clean your data imported from an external source.

  • Trim leading, trailing spaces and excess spaces between words
  • Change text case to Proper, UPPER, or lower
  • Convert numbers in the text format to the number format
  • Remove or replace unwanted and non-printing characters
  • Split cell contents
  • Add any text to the selected cells
  • Clear formatting in Excel.

Complete support for:

Remove spaces in Excel, change text case, remove characters, convert text to numbers - Cell Cleaner for Excel

How to delete excess spaces in your Excel tables

Remove leading and trailing spaces in Excel, trim blanks between words to one

Occasionally, extra spaces prevent some add-ins or functions from working correctly. Blanks before and after cell values, additional spaces between the words in your cells may be a problem when you filter, match or merge tables. You can polish up your data by deleting all unwanted spaces in one go. The Cell Cleaner for Microsoft Excel add-in will quickly remove leading and trailing spaces, trim spaces between words to one and delete non-breaking spaces ('&nbsp') from your worksheets.

More about trimming excess spaces.

Change text case

Change case in Excel cells to UPPER, lower, Proper, or capitalized

If you happened to import an Excel worksheet where the text case is totally wrong, it doesn't mean you need to fix it manually. Cell Cleaner offers an easy possibility to convert case in the selected cells. Just choose to convert to upper or lower case, to capitalize each cell or use proper case in the range you select and click Run.

More about converting Excel text case.

Add text

Add text to the selected cells by position

The Cell Cleaner add-in allows appending specific text to each cell of the selected range without having to type it manually. For example, you need to add @company.com to a column of several hundred user names. Just enter the text on the add-in pane and select the position for it in the cells. You can add text at the beginning or at the end of cells, before or after specific value, or append text by numerical order. Easily add suffixes and prefixes, numbers, strings, characters and symbols to the selected cells.

More about appending text in Excel.

Convert text

Converting text to numbers will make calculations easier

When copying numerical data to Excel, you can get it stored as text. You can also indicate that digits must be treated as text yourself if you use the apostrophe before them. Both options can cause problems with calculations or result in irregular sorting. With this nifty add-in you can quickly convert the digits back to number format and delete spaces and apostrophes at the same time.

If you have several characters here and there in your table that you need to replace with a different one, use the Convert characters option instead of repeating the same find-and-replace steps. It will substitute all the characters you enter individually.

Extra line breaks is another common problem that the add-in solves, you can simply replace them with spaces or any other characters. More about changing number format, replacing irrelevant characters and line breaks.

More about changing number format, replacing irrelevant characters and line breaks.

Split cells in Excel

Enter any combination of characters to split text in the selected column

When you're editing or reviewing an Excel worksheet, you may find a column of data to be split into two or more columns for sorting or extracting specific records. For example, cells with phone numbers may need to be split so that area codes are separated. Splitting text may seem a relatively simple task unless you have data next to the selected cells or you need to split cells to rows.

Cell Cleaner allows separating cell contents by character, mask, or by strings and lets you choose to place parts of data to columns or rows.

More about splitting cells in Excel.

Delete unwanted characters from the entire range

Remove special (non-printing) characters, numeric, text, or custom symbols

Your spreadsheet can contain irrelevant characters you used to remove one by one. The Cell Cleaner plug-in automates such tasks. Wipe out all non-printing characters like line breaks, delete all digits, letters or special mathematical, currency and letter like symbols and punctuation marks. Or just use the custom characters box and enter whichever values you need to remove.

In addition, you can remove characters or substrings by position. Easily delete characters depending on where they are in the range. It's possible to erase the first or last characters, find characters by their order, or remove everything before or after the entered text.

More about removing unwanted characters from Excel cells.

Remove formatting in Excel

Remove background and text color, borders and Conditional Formatting rules in your Excel table

Formatting in Excel is a good way to create more readable and effective worksheets. Suppose you have a large table with all kinds of fonts, alignments, colors and so on. Once you understand that these don't work for your sheet any longer. With Cell Cleaner you can clear any formatting from the selected cells lightning fast and keep the cell contents intact.

Instantly reset number format, alignments, font and its size, background and text color, remove Conditional Formatting rules and borders.

More about clearing formatting in Excel

With Cell Cleaner you can

  1. Delete leading and trailing spaces
  2. Remove spaces between words to 1 and wipe out " "
  3. Remove unwanted non-printing, numeric, text or custom characters from your cells
  4. Convert all words within selected cells to upper,lower case or capitalize each cell or word
  5. Convert number stored as text to number format
  6. Replace line breaks with spaces
  7. Replace or remove several individual characters in one go
  8. Replace or remove several individual characters in one go
  9. Remove characters and substrings by position
  10. Clear formatting in the selected range
  11. Add the specified text to any location in the selected cells
  12. Separate cell contents by character, by mask, or by strings
  13. Split column data to rows or to columns.
19.95
Buy now

Cell Cleaner for Excel screenshots

Remove leading and trailing spaces in Excel, trim blanks between words to one

Remove leading and trailing spaces in Excel, trim blanks between words to one

Change case in Excel cells to UPPER, lower, Proper, or capitalized

Change case in Excel cells to UPPER, lower, Proper, or capitalized

Add text to the selected cells by position

Add text to the selected cells by position

Enter any combination of characters to split text in the selected column

Enter any combination of characters to split text in the selected column

Remove special characters, non-printing symbols etc.

Remove special (non-printing) characters, numeric, text, or custom symbols

Remove characters depending on their location in the selected cells

Remove characters depending on their location in the selected cells

Clean cells of all unwanted characters in a click

Clean cells of all unwanted characters in a click

Convert numbers stored as text to number format, replace line breaks

Convert numbers stored as text to number format, replace line breaks

Converting text to numbers will make calculations easier

Converting text to numbers will make calculations easier

Remove background and text color, borders and Conditional Formatting rules in your Excel table

Remove background and text color, borders and Conditional Formatting rules in your Excel table

How to remove extra spaces in Excel

How to change case in Excel


Free Download
Free 15-day trial version, 15.46 MB

Cell Cleaner for Excel system requirements:

Microsoft Excel

  • Microsoft Excel 2016 (32- and 64-bit)
  • Desktop Excel included in Office 365
  • Microsoft Excel 2013 (32- and 64-bit)
  • Microsoft Excel 2010 (32- and 64-bit)
  • Microsoft Excel 2007
  • Microsoft Excel 2003

Operating System

  • Windows 10 (32- and 64-bit)
  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Vista (32- and 64-bit)
  • Windows XP (32-bit)
  • Windows Server 2003, 2008, 2012
  • .NET Framework 4.0 must be installed.

If you need to install the add-in for a group of users, or on a Terminal Server (servers farm) please see Corporate deployment

Cell Cleaner version

Current add-in version: 3.1
published on: 19-May-16

End-User License Agreement (EULA).

 
Contact us
 
  Publish your message on our forum
 

Please remember that we work from 8am to 4pm GMT, this is 4:00am to 12:00pm EST,
1:00am to 9:00am PST, and our public holidays may differ from yours.

Ultimate Suite for Excel Professionals
 
 
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard