I need to compile a log book. What i want to do is input the last 2 text
digits of the registration and have the spreedsheet return the complete
rgistration from a list of complete registrations.

Have you tried Data Validation? That should be a good option, as it would
enable you to select the Reg number from a drop down, if you do it
correctly.

Rob

"bobw40" wrote in message
...
I need to compile a log book. What i want to do is input the last 2 text
digits of the registration and have the spreedsheet return the complete
rgistration from a list of complete registrations.

Hi Bob,

ToolsAutoCorrectReplace text as you type will do that.

When using this option it is best to give all of your
replace items a unique identifier, something unusual like
|as |in |to
or
]as ]in ]to
or
qqas qqin qqto

It doen't matter what you use so long as it is something
that is unlikely to be typed in any other situation.

HTH
Martin



"bobw40" wrote in message
...
I need to compile a log book. What i want to do is input the last 2 text
digits of the registration and have the spreedsheet return the complete
rgistration from a list of complete registrations.