Try this:

=MID(A1,1,FIND("-",A1,1)-1)

HTH,
Elkar


"WDP" wrote:

Hi:

I am looking for a function that will allow me to do the following:

I have the following value in a cell

Williams Sanders-IT Manager

I want to extract the "name" only from the cell. Every row in this file is
setup the same way....ie....I need a formula that will look "LEFT TO RIGHT"
until a dash is found (-).......then give me the entire string to the LEFT of
the dash (-)

Can anyone suggest the function to make this happen????


Thank you

Warren Phillips