Need help with a formula in excel 2003
 

I'm trying to create like a translator where one text can be typed in and
anouther one displayed some characters will equal sometimes to more then one
characters
mostly its just 2 characters example lets say A1 is A and B1 equals to ay in
this case A1 equals to B1. I tried substute it works so far and quits i don't
know why though. If anyone has any ideas please i could use the help please
not the A in A1 actully stands for the font style i'm useing for that
character.

A1 B1
A ay

Need help with a formula in excel 2003
 

Try making a table of the translations and then use VLOOKUP() functions to
find the correct translation.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Stephen C." <Stephen wrote in message
...
I'm trying to create like a translator where one text can be typed in and
anouther one displayed some characters will equal sometimes to more then
one
characters
mostly its just 2 characters example lets say A1 is A and B1 equals to ay
in
this case A1 equals to B1. I tried substute it works so far and quits i
don't
know why though. If anyone has any ideas please i could use the help
please
not the A in A1 actully stands for the font style i'm useing for that
character.

A1 B1
A ay