is this possible?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raz - 10 Oct 2008 18:22 GMT

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.

Reply to this Message

Sean Timmons - 10 Oct 2008 18:29 GMT

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

> 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
[quoted text clipped - 8 lines]
> 5 Prince
> etc.

Reply to this Message

Raz - 10 Oct 2008 18:35 GMT

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

> Are you saying you will be entering up to 20 and your value after will always
> match?
[quoted text clipped - 15 lines]
> > 5 Prince
> > etc.

Reply to this Message

Sean Timmons - 10 Oct 2008 18:48 GMT

Oh, gotcha

Use Tools - AutoCorrect

Enter 1 replace with John

Etc.

Be sure to delete this when you're done.

> No
>
[quoted text clipped - 26 lines]
> > > 5 Prince
> > > etc.

Reply to this Message

Sean Timmons - 10 Oct 2008 18:49 GMT

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.

> No
>
[quoted text clipped - 26 lines]
> > > 5 Prince
> > > etc.

Reply to this Message

MartinW - 10 Oct 2008 20:15 GMT

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

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

> No
>
[quoted text clipped - 31 lines]
>> > 5 Prince
>> > etc.

Reply to this Message