This group contains tools to format numbers, change cases, and clean data.
Click this button to open a taskpane.
The first four options can be used to shorten numbers and convert them to numbers with Kilo (K), Mega (M), Giga (G), Peta (P), Exa (E), etc. These numbers are converted to text.
The last option adds a thousand separators. It’s formatted as a number.
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.