[Solved] Remove space at beginning/end of cell

[THEBookMan]

FIND & REPLACE
I want to find the space at the end of a cell and replace with "".
I want to find the space at the beginning of a cell and replace with "".

Have trioed several things like ;
^"", ^[], etc, but to no avail.

Any ideas ?

Thnak you,
⌡im [the BookMan]

[RoryOF]

Beginning of cell, Find ^<space> where <space> is a press of spacebar. Replace "" Drop More options and check Regular expressions

End of cell, Find <space>$, Replace "", set More Options as above.

[karolus]

Hallo
Search for:

Code: Select all

^\s+|\s+$

replace with semantically nothing ( ! no input in replace-field !)

[x] regular Expression

⇒ replace all