Automated imput partly

M

Matt_07

Im wanting to make it so TC07 comes up and and then the user can add 4 digits
to the end

For example tc07 4345

The 4345 would be imput but the user but the tco7 would already be there any
help
cheers
 
M

Mike

Without resorting to a macro, 1 way.

Put TC07 in a cell (say) C3

in B1 type =CONCATENATE($C$1," ",A1) drag down as required

your user then inputs the numbers in A1 and the 2 are added together in B1.
 
Top