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 · Accepted solution]

[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.

[msantoso]

thanks BenMoss !

It works fine

[TNShan]

Hello,

I'd like to inquire about a specific procedure. How can I modify characters within the data to display as empty cell instead of completely removing the data?

For example:

From	To
#
#12-12	#12-12
#Happy	#Happy

Your guidance in achieving this is much appreciated.

Thank you.