| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NAME function
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. F. Lawrence Kulchar wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NAME function
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NAME function
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 -- 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NAME function
Have you tried InsertNamePastePaste List?
Then editreplace the = signs with nothing. Gord Dibben MS Excel MVP On Wed, 10 Sep 2008 04:25:00 -0700, F. Lawrence Kulchar wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
