Extract within a cell

[Guest]

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

 

[Guest]

Try this:

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

HTH,
Elkar

 

[Guest]

WOW!

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

Have a ROCKIN evening

 

[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

Gord Dibben MS Excel MVP