Extract within a cell

W

WDP

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
 
G

Gord Dibben

Without formulas.....Data>Text to Columns>Delimited by>Other

Enter a hyphen and Finish.




WOW!

That is just what I needed.....Thank you very much.

Have a ROCKIN evening
Click to expand...

Gord Dibben MS Excel MVP
 
Top