Auto fill of specific text.

B

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.
 
R

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
 
M

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
 
Top