I am trying to replace a column of text, but only if the text DOESN'T say Incoming. How to I do a replace if cell is NOT Incoming? Thank for your help.

Dalynch

Not real clear, but perhaps this is the direction you are going, which requires an extra column.

If your original data is in Column A, Text ("Incoming" or something else), and the replacement value in Column D, then put this formula in Column B:

=IF(B1="Incoming",D1,A1)

Adjust to suit your specific needs.