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
Solved! Go to Solution.