Returning text using IF Function

Christa Brown

Hello!

I am trying to return text from another column that has a lot of text in. I'm using the IF, FIND, and RIGHT functions.. but it's not working. The intent is to search the DAQ Comments column for the word "PCI".. if it's there I want to return only one part of the text starting with the word "Other". If there is no match I want it to be left blank

The current formula looks like:

=IF(CONTAINS("PCI", [DAQ Comments]@row), (FIND("Other", [DAQ Comments]@row), RIGHT([DAQ Comments]@row, 2000)), "")'

Thank you!!

Mark Cronk

Hi Christa,

Try:

=IF(CONTAINS("PCI", [DAQ Comments]@row), RIGHT([DAQ Comments]@row, LEN([DAQ Comments]@row)-FIND("Other", [DAQ Comments]@row)+1), "")

Mark

Mark Cronk

Hi Christa,

Try:

=IF(CONTAINS("PCI", [DAQ Comments]@row), RIGHT([DAQ Comments]@row, LEN([DAQ Comments]@row)-FIND("Other", [DAQ Comments]@row)+1), "")

Mark

Christa Brown

Thank you again! I got it using the MID Function and the FIND function to give MID a starting point. PHEW!!

Mark Cronk

Glad you solved it. Thank you for using the Community.

Mark