NAME function

[F. Lawrence Kulchar]

I have in row 1:

Arizona Cardinals
Atlanta Falcons
Baltimore Ravens
BUF
CAR
CHI
CIN
CLE
DAL
DEN
DET
GB
HOU
IND
JAC
KC
MIA
MIN
NE
NO
NYG
NYJ
OAK
PHI
PIT
SD
SEA
SF
STL
TB
TEN
WAS

Each of my 2 or 3 letter abbreviations are defined in the NAME dialog box,
e.g. as follows:

For TB, I have: NAMES IN WORKBOOK TB
REFERS TO = "Tampa Bay
Bucs"

I wish to transscribe all my abbreviations to their individualized (refers
to) actual
names...

but I notice that within each cell, I must insert the "=" sign:

such as: =TB
or = STL
or = TEN

When I insert all 36 "=" signs, I get a fully alphatized report of names
without any abbreviations!!

QUESTION: IS THERE A METHOD TO SPEED UP THIS PROCESS, BECAUSE OVER A
VARIETY OF OVER 3 WORKBOOKS, I HAVE A COMPLETE PLETHORA OF THESE ABBREVIATED
NAMES...ALL HAVING TO BE CHANGED???

Thank you,

FLKulchar

 

[Dave Peterson]

Maybe you can use autocorrect.

In xl2003, it's under
tools|autocorrect options|Autocorrect tab

I would use a special character to make sure that those abbreviations are
changed only when I want them changed.

..TB
becomes
Tampa Bay

Or $tb or whatever you like.

If you go with the autocorrect options, this list will is shared in all of the
office applications.

 

[Don Guillett]

How about a nice worksheet_change event that when you enter TB looks up
Tampa Bay in a table? Or, for wholesale changes a for/each loop macro.

 

[Francis L. Kulchar]

I am Not familiar with macros,,,I wish my shortened abbreviations to become
completely spelled out.

 

[Francis L. Kulchar]

I had used the Define Name routine in other years's workbooks, but I have
forgotten how??

I ALSO NEED TO TRANSCRIBE THESE 36 ABBREVIATIONS TO APPROX, 6 OTHE .xls
files -- i.e. about 6 workbooks -- How is this done?

Thanks,

FLKulchar

 

[Gord Dibben]

Have you tried Insert>Name>Paste>Paste List?

Then edit>replace the = signs with nothing.


Gord Dibben MS Excel MVP