Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I automatically insert the latin tree names
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?? |
#2
|
|||
|
|||
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?? |
#3
|
|||
|
|||
My level of expertise is only minimal and relates only to our tree surveys
which are text and not figures. What do you mean by code used for Word? Also, have looked up Vlookup in help but it is over my head, I cant seem to work out a formula that works. "Vacation's Over" wrote: 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?? |
#4
|
|||
|
|||
sueCBA,
My experiment in Word 97 has Word replacing the text, not adding it to the line below? Excel has a similar "Auto Correct Options" feature found on the "Tools" menu. It replaces one set of characters with another set. It does not add the replacement set to the line below. Also, Excel will only accept additions to the list of replacements, one word at a time. This can be overcome using some simple VBA code which can add a list from a worksheet to the Auto Correct list. Glad to help you with that if you want to proceed. Jim Cone San Francisco, USA "sueCBA" wrote in message ... 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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically insert system time in a cell | Excel Discussion (Misc queries) | |||
how do I get an invoice to automatically insert the next invoice . | New Users to Excel | |||
Insert column entries from a master list | Excel Worksheet Functions | |||
Insert column entries from a master list | Excel Worksheet Functions | |||
Insert column entries from a master list | Excel Worksheet Functions |