Need Formula with IF

Waleed

Hi ,

I want to create this formula

IF the cell's text include specific word or sign than to change it to blank and the same formula condition but to change it to specific text

Thank you

Paul Newcome

Try something like this...

=IF([Column Name]@row = "word or sign", "", "specific text")

Waleed

Thank you @Paul Newcome ,

Im getting error , please see attached ( The formula can be seen at bottom )

The thing is that I do not whan to share phone number which start with + sign

Paul Newcome

You will need to put it in a different column. You cannot put the formula in the column you are referencing.