Hi

I need a formula to get say abcde for value 5, or ab for value 2.

is there any direct but short formula using array in single cell?

[I can do it with non-array formula, which is so long. I need short one.]

THANKS IN ADVANCE.