Data input and use of lookup text conversion

yellowcabguy

Active Member
Joined
Dec 28, 2005
Messages
440
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.
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

yellowcabguy

Active Member
Joined
Dec 28, 2005
Messages
440
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

Legend
Joined
Sep 3, 2002
Messages
10,473
Re: auto correct

yellowcabguy said:
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

Active Member
Joined
Dec 28, 2005
Messages
440

ADVERTISEMENT

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

Well-known Member
Joined
Apr 28, 2004
Messages
76,061
Office Version
  1. 365
Platform
  1. Windows
Works for me.:)
 

yellowcabguy

Active Member
Joined
Dec 28, 2005
Messages
440

ADVERTISEMENT

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

Legend
Joined
Sep 3, 2002
Messages
10,473
Re: auto correct

yellowcabguy said:
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

Well-known Member
Joined
Apr 28, 2004
Messages
76,061
Office Version
  1. 365
Platform
  1. Windows
Perhaps there's another entry for y?
 

yellowcabguy

Active Member
Joined
Dec 28, 2005
Messages
440
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,673
Messages
5,573,594
Members
412,537
Latest member
Mohamed_5966
Top