Combining Letters and Numbers

D

dippy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top