|
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
|