Writting number from columns in reversed order

I have this situation:

Please Login or Register  to view this content.

I need to write them in one cell in reversed order (C0G8) without zero in front.

number of columns is up to 28.

One way though not elegant:

=RIGHT(R1&Q1&P1&O1&N1&M1&L1&K1&J1&I1&H1&G1&F1&E1&D1&C1&B1&A1,MAX(IF(A1:R1<>0,COLUMN(A1:R1))))
committed with CTRL + SHIFT + ENTER

Non-Array version:

=RIGHT(R1&Q1&P1&O1&N1&M1&L1&K1&J1&I1&H1&G1&F1&E1&D1&C1&B1&A1,LOOKUP(2,1/(A1:R1<>0),COLUMN(A1:R1)))

I'm not sure I follow, so this:

Please Login or Register  to view this content.

does not work ?

On an aside - if you went with morefunc.xll you could use MCONCAT / TXTREVERSE, ie:

C5:
=RIGHT(TEXTREVERSE(MCONCAT(D5:AE5)),LOOKUP(2,1/(D5:AE5<>0),COLUMN(D5:AE5)-3))

or

=TEXTREVERSE(MCONCAT(D5:INDEX(D5:AE5,LOOKUP(2,1/(D5:AE5<>0),COLUMN(D5:AE5)-3))))

You could use a function to do the base conversion:

Please Login or Register  to view this content.

For example,

=Dec2Base(2^31-1, 2) = 1111111111111111111111111111111
=Dec2Base(2^31-1, 16) = 7FFFFFFF
=Dec2Base(2^31-1, 36) = ZIK0ZJ

Or you could modify the formula in D5 (and copied across and down) to make the numbers come out in the right order:

=LOOKUP( MOD(INT($C$1 / $B5 ^ (28 - COLUMN(A1) ) ),$B5 ), $B$3:$B$38)