I'd create a small table on another worksheet.

Put the abbreviations in column A and the long names in column B.

=vlookup(a1,sheet2!a:b,2,false)

to return the longer name.

brookdale wrote:

Anyone have any ideas at all?

--
brookdale
------------------------------------------------------------------------
brookdale's Profile: http://www.excelforum.com/member.php...o&userid=24617
View this thread: http://www.excelforum.com/showthread...hreadid=382076

--

Dave Peterson