Help urgent help for simple numeric combination problem

[huat08]

Hi guys,

I need some urgent help on combination of numbers


on the extreme left column, i have 23 numbers from A1:A23. All 23 numbers are in the form of 4 digit. For example A1 there is 1234, i need to display the possible 3 digit combination of this in the same row (like say 123,124,234,134 in B1,C1,D1 AND E1).

Another example in A2 there is 3545, i need to display 354,455,355 in the same row in B2,C2,D2

I need to perform this operation for the 23 numbers on the extreme left row. Can anyone give me some hint on the code please. Thank you

 

[mikerickson]

See post#8 re:0925

 

[huat08]

thank you everyone for helping. really appreciate your kind assistance esp bro mike. Have a good day