Extract within a cell
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
|