REMOVEIRRSPACE

Removes irregular spacings in the input text string.

Empty space before a string, empty space at the end of a string, or consecutive spaces within a string are considered as irregular spacings.

Syntax

REMOVEIRRSPACE(input_string)

input_string - string expression (or the reference to a cells) from which irregular spacings are to be removed.