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

D

Deva

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.
 
D

David Biddulph

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