Combining Letters and Numbers
 

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

Combining Letters and Numbers
 

=Output1&Output2

Replace Outputs by cell references, like A3&A4

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"dippy" wrote in message
...
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