Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    Manchester, NH
    Posts
    57

    Unanswered: Edit Replace function

    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

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Quote Originally Posted by dalynching
    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.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •