Hi John,

You would have to use an IF statement, for example suppose they enter either
English or French in cell A1, in B1 you might have a formula like:

=IF(A1="English","Yes","Oui")

--
cheers,
Shane Devenshire


"JohnAin" wrote:

How can I load a text cell with either english or French depending on what
language the user chose?