IF Contains

[cmjunk]

Hello,

I am trying to perform a IF Contains formula on a specific number. For example, if column {x} contains any number "5", then create new column {y). However, when I do this, I get number that have a 5 in them, such as "52", "505", "5." What I need is only the "5", and nothing else. Is there an easy way to do a if contains formula on a specific number essentially?

Thanks,

Chan

[fmvizcaino · Accepted solution]

Hi @cmjunk ,

See if it is this what you are looking for.

Best,

Fernando Vizcaino