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...