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?

I think can. VBA can be used for it. A bit of programming involved.

paranoid,


Yes, the Excel able to do that via the coding. Other than that, you can use the formula (can be very complicated) to generate the desire output, this is only applicable for a fixed lenght and pattern of the data.

For your case, I would encourage you use code the login in VBA to generate the output.


Happy Coding & Valentine's Day

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

can VB output be exported into excel format?

paranoid,


Yes. VB able output the format to Excel format. The simpliest way is to generate the output to CSV.

You can find the sample code at FreeVB Code.


Happy Coding