These Microsoft Excel apps from AbleBits.com are extremely beneficial.
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.
The Random Generator app for Excel populates the selected cells with random integers, reals, and dates.
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 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.
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.
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.
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.