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