How to remove "?" in colunm

[TheSAguy]

Hi,

I have an excel file and in my address 2 field I sometimes have the character ? that I want to remove.

I think because "?" is a special character, I'm not able to "catch" it.

My workflow:

Data:

Thanks.

[DataNath]

@TheSAguy under the 'Replace Found Text With Value' configuration, you've selected your [Word_To_Find] field instead of [Replace_With] so you're just replacing ? with ? at the moment.

Alternatively you could just try using a Formula tool with an expression like:

if [ADDR_LINE2] = '?' then null() else [ADDR_LINE2] endif

[binu_acs]

@TheSAguy You need to mention at least a space in the replace field

[Luke_C]

Alternative formula on Address 2:

Replace([ADDR_LINE2],'?','')

Assumes valid addresses don't have a question mark in them, which I think is a fair assumption. 

[TheSAguy]

Thanks for the feedback