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.

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.

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.

Oh, gotcha

Use Tools - AutoCorrect

Enter 1 replace with John

Etc.

Be sure to delete this when you're done.

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

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.

Hi Raz,

If you are going to use Auto Correct, as Sean suggests,
it is best to use a unique character before your number such as
[1
]1
|1
or whatever, it makes no difference what character you use
so long as it is a keystroke you are unlikely to use anywhere
else in your spreadsheet.

Alternatively you could use a helper column
with a VLOOKUP formula in it.

HTH
Martin


"Raz" wrote in message
...
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.