Text

This group contains tools to format numbers, change cases, and clean data.

Graphical user interface, application

Description automatically generated

Humanize

Application, Teams

Description automatically generated

Click this button to open a taskpane.

Graphical user interface, text, application

Description automatically generated

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.

A screenshot of a computer

Description automatically generated with low confidence

Change Case

Text, schematic

Description automatically generated

Clicking this button reveals additional subbuttons.

Text, table

Description automatically generated with medium confidence

Each of these buttons is responsible for changing the case of letters.

Graphical user interface, text, application, chat or text message

Description automatically generated

Trim and Combine

Graphical user interface, application, Teams

Description automatically generated

Clicking this button will reveal two subbuttons.

Text

Description automatically generated with medium confidence

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.

Graphical user interface, text, application, table

Description automatically generated