Data input and use of lookup text conversion

[yellowcabguy]

Rather than adding a text string (Dog Training) in a cell is there a way to enter a one or two digit code (DT) and have Excel automaticlaly convert DT to Dog Training? Have about 7 diffenent potential codes.

 

[just_jon]

Sure, have a look at Tools | AutoCorrect .

 

[yellowcabguy]

auto correct

I must be having a senior moment.

Using Auto COrrect added GO to be replaced by Golden Outreach.

However when I type GO in a cell it does not convert.

ANy thoughts

 

[just_jon]

Re: auto correct

I must be having a senior moment.

Using Auto COrrect added GO to be replaced by Golden Outreach.

However when I type GO in a cell it does not convert.

ANy thoughts

No, that should do it.

 

[yellowcabguy]

auto correct

using auto corect I got all my one or two digit codes to replace with text EXCEPT "y: replaced with "Yes"

That will not work. Any thougths?

 

[Norie]

Works for me.

 

[yellowcabguy]

auto correct

weird

If i try to get "y" to got to "Yes" it does not work

If I make "ys" go to "Yes" it works.

Any thoughts?

 

[just_jon]

Re: auto correct

weird

If i try to get "y" to got to "Yes" it does not work

If I make "ys" go to "Yes" it works.

Any thoughts?

Is there something in the Exceptions, maybe?

 

[Norie]

Perhaps there's another entry for y?

 

[yellowcabguy]

auto correct

go figure

I shut down excel and opened it again and now the y to Yes works. Beats me.

Now if I can get a response to my post on listing I think I have everything answered.

Thanks