I have 2 values that i convert into a specified letter and the other a
number. I need to take those 2 cells and combine them into their respective
letter combinations.

For example.
Data imput one produces A and 4 in 2 different cells. I need to have a new
cell that combines these into A4

As another example,
Input1 Input 2 Output1 Output2
6 2234 A 3

I need thoser 2 outputs to combine into one cell as A3