does microsoft excel offer enough functions to generate desired output based on what is typed?

for eg.
column A, i type "123ABC"
then i would expect column B to output maybe somthing like "one A two Bs and three Cs"

something like column A to capture specific character in that string and give output on column B. and the output is preset? like A will give this output and B will give another output?

thanks.. it would be easier to do everything on VB then??

can VB output be exported into excel format?