Or, if you have 1 in other places, put in your numebrs, then when done, use
Find/Replace

Find 20, replace with Bill, etc.

Start from highest number down. Otherwise 11 will become JohnJohn.

"Raz" wrote:

No

I want the number to change to text

for example my colmn is A
so if I enter 1 in A1, and press enter, 1 should change to John

i have code numbers 1 to 20 for 20 different names. I want to type code
numbers instead of whole name, but need the same cell to show the right name
for right code number


"Sean Timmons" wrote:

Are you saying you will be entering up to 20 and your value after will always
match?

Once you enter each of them once, every time after that, autocomplete should
assume you want the same value again.. So, enter 1 John once, any time you
start entering it down the column, it should assume the John part...

"Raz" wrote:

i have a long column, where my inputs going to be 1 to 20 (manual)
but in the same cell I would like them to change to certain text as I type

for example,
if I type 1 and press enter, it should change to the word "John"
i.e,
1 John
2 Ron
3 Rob
4 Ross
5 Prince
etc.