I have a list of product parts formated as text. I would like to
truncate the first part of the each text field before a hyphen is one
exists. How do I go about doing this using a function. TIA TOM



--
tcjay


------------------------------------------------------------------------
tcjay's Profile: http://www.excelforum.com/member.php...fo&userid=4072
View this thread: http://www.excelforum.com/showthread...hreadid=422515