DEV Community

loading...

Free AbleBit Apps for Microsoft Excel

gamesover profile image James Moberg ・2 min read

These Microsoft Excel apps from AbleBits.com are extremely beneficial.

Excel Apps from AbleBits

Trim Spaces

https://appsource.microsoft.com/en-us/product/office/WA103651566

Extra spaces can creep in when you get data from different sources. These extra spaces might prevent you from sorting, processing data, making calculations or creating charts. You can clear the cells of leading, trailing, or other excess spaces by following a few simple steps.


Random Generator

https://appsource.microsoft.com/en-us/product/office/WA103982219

The Random Generator app for Excel populates the selected cells with random integers, reals, and dates.


Random Sorter

https://appsource.microsoft.com/en-us/product/office/WA103985973

This randomizing app for Excel 2013 lets you shuffle entire rows and columns without losing data integrity. You can also mix cells within rows or columns, or put all selected cells at random. When you need to put names in random order or mix sequential numbers, this app makes your choice unbiased.


Remove Unwanted Characters

https://appsource.microsoft.com/en-us/product/office/WA103982221

Remove Unwanted Characters app goes through the selected Excel range and takes out all impeding characters according to your settings. You can clean your table of all non-printing characters and line breaks. Easily delete special mathematical, currency and letter-like symbols, punctuation marks, and any custom character you enter.


Change Case

https://appsource.microsoft.com/en-us/product/office/WA103982217

If you get Excel tables from different sources, your data are likely to be discordant. You can run the Change Case app to make all cells look right at once; upper, lower, proper-case and first letter in each cell.


Merge Cells

https://appsource.microsoft.com/en-us/product/office/WA104036095

This simple yet powerful app allows you to merge the contents of the cells in your Excel 2013 table any way you like. Feel free to combine values in each row, column, or bring all values in the range together. You can enter a delimiter for the merged values and choose where you want to have the results.


Range Calculations

https://appsource.microsoft.com/en-us/product/office/WA103996219

The Range Calculation app comes in very handy when you need to recalculate numbers in many cells. Ranges and tables of prices are easy to handle: divide, multiply, add and calculate percentage in the entire range by clicking the "Calculate" button.

Discussion

pic
Editor guide