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

--
Francis L. Kulchar
"Don Guillett" wrote in message
...
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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"F. Lawrence Kulchar" wrote
in message ...
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