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

[TNShan]

Hello,

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

In my column, some cells contain a single "#". And I want to remove it. 

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

For example:

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

Your guidance in achieving this is much appreciated.

Thank you.

[ShankerV · Accepted solution]

Hi @TNShan 

Please use the below in Formula tool.

Column name: To

IF Length([From]) = 1 AND [From] = "#"
THEN Null()
ELSE [From]
ENDIF

Many thanks

Shanker V

[TNShan]

I extend my heartfelt gratitude for your invaluable assistance. I am pleased to share that your guidance has enabled successful implementation. Thank you immensely for your support.