Remove a character when it is the only character in the cell

msantoso

Hi everyone, 

I cannot figure out how to do this cleaning...

In my row, some cells contain a single dash. And I want to remove it. 

but other cells contain also a dash with other characters. And in that case, I need to keep the dash. 

Example

-

RRR-1535

RRR 1242-U REUTLINGEN

RRA-NR. 19521

thank you for your help

Myriam

BenMoss

[Field] = '-'

Would be my bet, in this case the entire string of the field has to match.

Alternatively if there are other single characters you could do...

Length([field]) = 1

Using a filter tool in both scenarios of course.