Truncating text before a hyphen
 

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


--
tcjay


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

Cancel that request. I just used replace from the main menu. ;)


--
tcjay


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