Can someone help with following formula - need to extract value

sedanoh

Hi,

Hoping someone could assist me with creating a formula that would allow me to get specific value from a field.

Our system gives us the Description field which contains data we want to use to further separate our data. I have tried various formulas but I run into issues since the numeric part can be 1 to 3 digits. Only an empty space separates the text I want to pull which is the field labeled What I want.

Thank you in advance for your help!

Nic Larsen

Try this:

=IF(CONTAINS("Return", Description@row), "Return", IF(CONTAINS("Special", Description@row), "Special", IF(CONTAINS("Standard", Description@row), "Standard")))

Nic Larsen

Try this:

=IF(CONTAINS("Return", Description@row), "Return", IF(CONTAINS("Special", Description@row), "Special", IF(CONTAINS("Standard", Description@row), "Standard")))

sedanoh

Thank you very much! I was close - I was missing the Contains function.