Let me know the formula for getting particular text from a cell
 

Hi

If I have a list of Names in an Excel Worksheet. I want only a Particular
Text from a cell .for Example:

Name List
-------------
Daniel David
Anne George
Angle wilson

From the above List , I want only the first name from the Name List (like
Daniel ). Do we have any Formula for finding it.

Kindly Suggest me.

Thanks,
Deva.

Let me know the formula for getting particular text from a cell
 

Try

=LEFT(A1,FIND(" ",A1))

Mike

"Deva" wrote:

Hi

If I have a list of Names in an Excel Worksheet. I want only a Particular
Text from a cell .for Example:

Name List
-------------
Daniel David
Anne George
Angle wilson

From the above List , I want only the first name from the Name List (like
Daniel ). Do we have any Formula for finding it.

Kindly Suggest me.

Thanks,
Deva.

Let me know the formula for getting particular text from a cell
 

Or =LEFT(A1,FIND(" ",A1)-1) if you don't want the trailing space in the
result.
--
David Biddulph

"Mike H" wrote in message
...
Try

=LEFT(A1,FIND(" ",A1))

"Deva" wrote:

Hi

If I have a list of Names in an Excel Worksheet. I want only a Particular
Text from a cell .for Example:

Name List
-------------
Daniel David
Anne George
Angle wilson

From the above List , I want only the first name from the Name List (like
Daniel ). Do we have any Formula for finding it.

Kindly Suggest me.

Thanks,
Deva.

Let me know the formula for getting particular text from a cel
 

thanks!!!

"Mike H" wrote:

Try

=LEFT(A1,FIND(" ",A1))

Mike

"Deva" wrote:

Hi

If I have a list of Names in an Excel Worksheet. I want only a Particular
Text from a cell .for Example:

Name List
-------------
Daniel David
Anne George
Angle wilson

From the above List , I want only the first name from the Name List (like
Daniel ). Do we have any Formula for finding it.

Kindly Suggest me.

Thanks,
Deva.