Lots of ways to do this depending on your level of expertise in Excel

If you have access to the code used for Word that would help.

The simple way in Excel would be to have a workbook with 2 sheets:
sheet1 - that has 2 columns tree & latin tree

sheet2 using formula =Vlookup for the latin column of your working sheet you
could have the latin column autofill

look in help for vlookup but it basically looks for a value in one column
and returns the value in an adjactnt colunm.

"sueCBA" wrote:

We are arboriculturists who use autotext to complete tree names
e.g.

Pedunculate Oak
Quercus robur

We type Pedunculate and hit F3 and the Latin is inserted on the line below
in italics.

This is in €˜Word. Does anyone know how we can do this in Excel 2002??