=Left(SUBSTITUTE(RIGHT(CONCATENATE(U14,V14,W14,X14 ,Y14,Z14),6),0,"")&"000000
",6)

--
Regards,
Tom Ogilvy

"Paul Black" wrote in message
...
I have come up with the Formula ...

=SUBSTITUTE(RIGHT(CONCATENATE(U14,V14,W14,X14,Y14, Z14),6),0,"")

.. which does what I want and gets me to ...

111111
3111
21111
2211
321

The Only thing I Need is to get it to Fill the Right Side of the Result
with Zeros Making it a 6 Digit String ...

111111 Becomes 111111
3111 Becomes 311100
21111 Becomes 211110
2211 Becomes 221100
321 Becomes 321000

Thanks in Advance.
All the Best.
Paul



Sorted Fixed Length String
From: Paul Black

Thanks for the Reply Bob,

I have Changed the Concatenate Formulas so they Now Produce the String
in the Following Format :-

00000111111
00030111
000021111
00002211
000321

In the Next Column I have Used the Formula ...

=RIGHT(A1,6)

.. which Produces :-

00000111111 Becomes 111111
00030111 Becomes 030111
000021111 Becomes 021111
00002211 Becomes 002211
000321 Becomes 000321

Now what I would like is for it to Remove ALL the Zeros so ...

00000111111 Becomes 111111 Becomes 111111
00030111 Becomes 030111 Becomes 3111
000021111 Becomes 021111 Becomes 21111
00002211 Becomes 002211 Becomes 2211
000321 Becomes 000321 Becomes 321

.. and then Put 0's at the End so it is Still a 6 Digit String, so ...

00000111111 Becomes 111111 Becomes 111111 Becomes 111111
00030111 Becomes 030111 Becomes 3111 Becomes 311100
000021111 Becomes 021111 Becomes 21111 Becomes 211110
00002211 Becomes 002211 Becomes 2211 Becomes 221100
000321 Becomes 000321 Becomes 321 Becomes 321000

Thanks in Advance.
All the Best.
Paul


*** Sent via Developersdex http://www.developersdex.com ***