These Microsoft Excel apps from AbleBits.com are extremely beneficial.
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.
Top comments (0)