TRIM

Deletes every space in a text string except one space between letters or text strings

Syntax of Excel Trim formula:
=TRIM(text)

In words:
=Trim all unnecessary spaces(in this text)

Examples of Excel Trim formula

=TRIM(.       P    ak           Accountants      .) will return
“. P ak Accountants .”