LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Jim Cone
 
Posts: n/a
Default

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??

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically insert system time in a cell PM Excel Discussion (Misc queries) 2 December 30th 04 04:56 PM
how do I get an invoice to automatically insert the next invoice . curse New Users to Excel 2 November 27th 04 02:23 AM
Insert column entries from a master list RichLorn Excel Worksheet Functions 1 October 28th 04 10:37 PM
Insert column entries from a master list RichLorn Excel Worksheet Functions 0 October 28th 04 08:59 PM
Insert column entries from a master list RichLorn Excel Worksheet Functions 0 October 28th 04 08:57 PM


All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"