How to combine 4 Decimal numbers into a Hex number

Hi

How to combine 4 Decimal numbers into a Hex number.

If I have 4 decimal numbers each number is max 1 or 2 decimal digits and I have these in A, B, C and D Columns then how can I use some formula to combine these into a Hex number?

The size of hex number will be 4-hex digits, that is 16-bits long. These 16-bits are divided in 4 groups of bits as follows:

16-bits => (5-bits)--(1-bit)--(5-bits)--(5-bits)
16-bits => 10101 --- 1 ------ 00001--- 00011
Decimal => 21 ----- 1 ----------1 ------- 3
Hex number => AC23

So if I write 21, 1, 1, 3 in Col A, B, C, D then how can I get 'AC23' in Col E as shown in following image?

21.jpg

This post is reverse of my previous post on this forum in which I wanted to break a given Hex number into 4 decimal numbers.
Its Title was "Converting HEX value to BIT-fields", and ID=1304645.

What will be Cell-Format to make this formula work? Should it be 'General', or 'Number', or 'Text' or something else?
Will I get the result displayed in HEX format?

Your very first formula gives right results.
The later 3 formulas are not working. I get this result for them:

Attachment 661312