ExcelBanter - Automated imput partly

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Automated imput partly (https://www.excelbanter.com/excel-worksheet-functions/128311-automated-imput-partly.html)

Matt_07

Automated imput partly

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

--
Matt

Mike

Automated imput partly

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.

"Matt_07" wrote:

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

--
Matt

Teethless mama

Automated imput partly

Try this:
Custom Format

"tc07 "0

"Matt_07" wrote:

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

--
Matt

All times are GMT +1. The time now is 07:36 PM.