Just 1, 2 and 3? Are you going to go past 9/I? In VBA, Chr(65) returns A,
Chr(66) returns B, Chr(67) returns C etc.

HTH

"Marcelo" wrote:

Guys,

I am looking for a way to separate digits using VBA, for example. if I have
123 in one cell, and I would like to have a function transforming 1 in A, 2
in B, etc, so the function for 123 should return ABC or CBA for 321.

best regards.

Marcelo from Brazil