I assume you're talking about an Excel sheet? You could do with spending a little more time on your questions, it is really not very clear what you need.
Do you mean you want a 3rd cell where the number and initial letter are joined together?
Huawei P10 review
1995-2015: How technology has changed the world in 20 years
An overview: What leading creative agencies are doing to improve diversity
New iPad, iPhone SE & Red iPhone 7 on sale now
Synology invites you to visit them at Insomnia on 26th – 29th August. Book your tickets now and visit Synology.