View Single Post
  #2   Report Post  
Gary''s Student
 
Posts: n/a
Default Excel Language worksheet

Hi Tim:

Use the =SUBSTITUTE() function. It will translate words or even phrases
from one language to another.

Have a good day.
--
Gary's Student


"Tim" wrote:

Hi, I am trying to create a worksheet where I can type in a sentence in a
cell and the cell below it will display the sentence converted to a different
defined language. So if I typed in something like "She is not nice" into a
cell, excel would search the worksheet for the correct conversion and in the
cell below, list the conversion. If in my new language "She is not nice"
would come out as "Ie nae aeoch gehagh. Any ideas on how to set this up?
Thanks!

Example: She is not nice
le nae aeoch gehagh
She = le
is = nae
not = aeoch
nice = gehagh