C8 is either blank, or has a 1,2,or 3 in it. I want R8 to populate with either a 1 (for 1,2, or 3) or be left empty.

I'm self taught and have figured out how to make one number populate the way I want, just not all 3.

Thanks so much!