Need help with a formula in excel 2003

G

Guest

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
 
S

Sandy Mann

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
UDF/Formula to replace only specific 3
formula help 2
Help with a date formula 1
formula 3
Please help with countif formula 4
If/Then formula using ranges 5
Media Analysis formula---Need Help 1

Top