Hello,

Not sure how to explain what i want but here is an example:

3B-50
3B-88
3B-99
3B-101
3B-568

I do not want to have to enter "3B-" over 200 times. Is there a way i can format cells to make my life easier? The numbers after the "3B-" are random.

Thanks!