HelpMePleaseThanks
New Member
- Joined
- Jul 19, 2018
- Messages
- 2
If anyone could help me that would be awesome.
I have a column with lots of data in the format of C11-00XX-XXX (the x's could be any number). This data correlates to a model name for example C11-0000-XXX through C11-00005-XXX is Model 1 and C11-00012-XXX is also Model 1(why they did it this way I am not sure). I want to convert these to their actual name (Model 1) how would I get an if statement to find these correctly and output the Model 1 if correct?
I have a column with lots of data in the format of C11-00XX-XXX (the x's could be any number). This data correlates to a model name for example C11-0000-XXX through C11-00005-XXX is Model 1 and C11-00012-XXX is also Model 1(why they did it this way I am not sure). I want to convert these to their actual name (Model 1) how would I get an if statement to find these correctly and output the Model 1 if correct?
