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

=Output1&Output2

Replace Outputs by cell references, like A3&A4

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"dippy" <(E-Mail Removed)> wrote in message
news:E2C4F44F-0063-46DD-A7B4-(E-Mail Removed)...
>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
>