Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel (2003) formula | Excel Discussion (Misc queries) | |||
Need Help With a Excel 2003 Formula | Excel Worksheet Functions | |||
Excel 2003 Formula | Excel Discussion (Misc queries) | |||
Can I get help with an excel 2003 formula | Excel Worksheet Functions | |||
Excel 2003 - Need Formula Help | Excel Discussion (Misc queries) |