trim

Previous chapterNext chapter Show allShow all    Hide allHide all

The function trim (string) deletes all multiple blanks from a textstring leaving only one between two words.

Syntax: =trim(string)

Example Example

Cell A1 = A.b..C...d....E.....f
=trim (A1) ist A b C dEf