tycasey17
Board Regular
- Joined
- Sep 26, 2013
- Messages
- 93
- Office Version
- 2019
- 2016
- Platform
- Windows
I am trying to figure out how to detect if a code has a letter in it no matter where in the string of text.
I have a formula giving out codes like this "DR", "RD", "CD", "CR-M", etc. in A1. I am trying to get either "Y" or "N" in A2 if one of the codes contains an "R" in the code. I tried using the LOOKUP function but can't seem to work it right or maybe it's not the best formula to use.
I have a formula giving out codes like this "DR", "RD", "CD", "CR-M", etc. in A1. I am trying to get either "Y" or "N" in A2 if one of the codes contains an "R" in the code. I tried using the LOOKUP function but can't seem to work it right or maybe it's not the best formula to use.