Function or formula to return a value in 2007

[MJZ64]

Hello Excel forum I am a graphics person with no experience with Excel other than coping information out of it.

I’m wondering can the following be done in Excel and if someone has an example or can tell me where I could find one or something similar to follow the steps?

I have the alphabet from A to Z and each letter has a corresponding code to represent it for example A = El1, B = khju1, C = E1ks and so on. What I would like to figure out is how to have Excel return the value separated by a space for each character after a acronym or strings of acronyms are imported.

Using the letters above an example of this would be after enetering (ABC) in a field I would recieve the following in the next field after a function or calculation was executed (El1 khju1 E1ks)

Thank you MJZ

I'm guessing it may look something like this after a formula is run.

Capture.JPG

[mehmetcik]

Hi

Aa you need is a user defined function

Please Login or Register  to view this content.

First paste this into your worksheet in the same area as your macros.

Then extend MyArray to include all your modified character codes, remember to end with a space

the sample worksheet attached uses the function coded in cells B1 to B4