| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace a long list of abbreviations with full words in Excel
that's it. Thanks.
"SteveG" wrote: If your list of abbreviations are in A2:A1000 and your reference table is Short name column I and Long name in column J then insert a helper column so in B2, =VLOOKUP(A2,I2:J7,2,FALSE) Copy the formula down your list. CopyPaste SpecialValues the results over the data in column A and delete the helper column. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=509458 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you display numbers as words in excel (eg. 10 as ten)? | Excel Discussion (Misc queries) | |||
| Get excel to list values that occur within raw data | Excel Discussion (Misc queries) | |||
| more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
Threaded Mode
