This group contains tools to format numbers, change cases, and clean data.
Click this button to open a taskpane.
The first four options shorten numbers and convert them to numbers with Kilo (K), Mega (M), Giga (G), Peta (P), Exa (E), etc.
The last option adds a thousand separators.
Clicking this button reveals additional subbuttons.
Each of these buttons is responsible for changing the case of letters.
Trim and Combine
Clicking this button will reveal two subbuttons.
Trim Whitespaces – Removes whitespaces from the beginning and the end of the string inside a cell.
Combine Spaces – Combines multiple adjacent spaces into a single space.