Apache OpenOffice Community Forum

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]

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.

Hallo
Search for: replace with semantically nothing ( ! no input in replace-field !)

[x] regular Expression

⇒ replace all