Auto fill of specific text.

[bobw40]

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.

 

[RobN]

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

 

[MartinW]

Hi Bob,

Tools>AutoCorrect>Replace 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