IF...OR...AND.. - Whatever it takes to solve this

[Frank Bacchus]

Hi All:

Attached is a sample file with two columns (Incoming Ticket and Result Ticket). The Incoming Ticket cell is the ‘raw’ data and the Result Ticket cell is desired results, Using an IF/OR or any other applicable operator to get the Result Ticket value, as shown in the sample file, is the goal. As an example, if the Incoming ticket cell has https://Y2I5.sys.Interest.net/browse/ABCEDF-45134, I would like the Result ticket cell to have ABCEDF-45134. Blanks in both cells should return blanks (not ‘False’).

Please let me know if you have any questions. Thanks.

frank

 

[Nebu]

Hi:

If your incoming ticket column will not take any other format than what you have in your attached file, you can use the following formula.

=IF(A2="","",IF(ISNUMBER(VALUE(A2))=TRUE,"ABCDEF-"&A2,"ABCDEF-"&RIGHT(A2,LEN(A2)-SEARCH("-",A2))))

Thanks