.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!
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!