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

Extract within a cell
 

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

Extract within a cell
 

WOW!

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

Have a ROCKIN evening


"Elkar" wrote:

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

Extract within a cell
 

Without formulas.....DataText to ColumnsDelimited byOther

Enter a hyphen and Finish.




On Thu, 24 Aug 2006 16:42:02 -0700, WDP wrote:

WOW!

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

Have a ROCKIN evening


"Elkar" wrote:

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

Gord Dibben MS Excel MVP