Prev: look up
Next: VBA moving and adding data
From: dippy on 7 Jan 2010 11:51
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

From: Niek Otten on 7 Jan 2010 11:55
=Output1&Output2

Replace Outputs by cell references, like A3&A4

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"dippy" <dippy(a)discussions.microsoft.com> wrote in message
news:E2C4F44F-0063-46DD-A7B4-F18061C62B3B(a)microsoft.com...
>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
>

 | 
Pages: 1
Prev: look up
Next: VBA moving and adding data