Truncating text before a hyphen

[tcjay]

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]

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