Deleting blanks after characters in google sheet cells-CodePudding

let's say I have a google sheet columns that holds the following

Phrase 1
Phrase 2
Phrase Word blabla 3

Now after the "2" of the second point there is a blank space. How would I delete the blank space in every cell if it's the last character in the cell?

Best, Florian

CodePudding user response：

Use the TRIM function - this removes trailing, leading and repeating space characters in cells.

CodePudding user response：

To remove ONLY a single tailing space, last character in the cell use this formula.

=ArrayFormula(IF(RIGHT(A2:A)=" ",LEFT( A2:A,LEN(A2:A)-LEN(RIGHT(A2:A)) ),A2:A))

Breakdown:
1 - logical_expression of the

Output

To remove all additional spaces dynamicaly in column A:A past this formula in cell A2.

=ArrayFormula(IF(A2:A="",,TRIM(A2:A)))

Breakdown:
1 -

Formula

Output