Adding Extract "fluff" Characters to a Value

[Mstg007]

.Adding Extra Characters

I have the following data in list:
100
100RD
100RD_A
100RD_B
101
102
102RD
103
103RD
103RD_A
etc...
I have a sort VBA setup which works fine with the numbers and just the "RD" part. I am wondering how I can have a formula look at a value and add a "fluff" characters to the value.
example
100----
100RD--
100RD_A
100RD_B
101----
102----
102RD--
103----
103RD--
103RD_A
I tried to sort with the above values and it worked.

So I am wanting the fomula to look at the value and add "-" dependent on the missing extra values. I sure hope this makes some sense! Thanks for any help!

 

[Rick Rothstein]

Occasionally we get it with 1, 2, 3, etc... in the same fashion as above.

So, did the formulas I posted in Message #9 work for you or not?

 

[Mstg007]

Worked like a charm!