| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NAME function
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Threaded Mode
