I have a List of NFL teams in a series of rows that I wish to convert to
their respective abbreviations:

For Example, In Column A, rows 1 -36, I have all the NFL teams as follows:

A

1 Kansas City
2. Oakland
3. Houston
4. Cincinnati
5 Arizona
6. Miami
7. Tampa Bay
8. Carolina
9. St. Louis
10. Detroit
11. New Orleans
12. Pittsburgh
13. Jacksonville
14. Cleveland
15. Green Bay

etc, etc, down to Row 37 for all 36 teams. I have used the INSERT Menu,
Define NAMES, so that:

Names in workbook: Kansas City
= KC
and,
Oaklank
= OAK

and so on.....

So when I type in cell B1, "=Kansas City"...B1 becomes KC
When I type in cell B2, "=Oakland"...B2 becomes OAK

THIS TAKES A LOT OF TYPING TO CONVERT THE NFL NAMED TEAMS (AS IN COLUMN A),
TO THEIR RESPECTIVE ABBREVIATIONS...

If I try typing in cell B1 "=A1", I get AGAIN "Kansas City"...NOT "KC" as I
would like to see!

Can anyone help me out their to convert the NFL 'long names' which I paste
from a website to their respective abbreviations.

I do use a VLOOKUP routine to later, on a different spreadsheet, search for
the needed abbreviations; ergo, the reason I require a 'short way' to convert
a column of lomg NFL teams, such as "Chicago Bears" to "CHI"...!

Please help.
Thanks,

The method I am using requires typing 36 times, into 36 cells, long entries
such as..."= Baltimore", or "=Indiannapolis"...all of which is too time
consuming.


Thanks again,

FLKulchar