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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using text in a cell in a formula 2
Formula text in woorksheet cell 2
Referencing worksheet names from a list?? 3
Use Formula to Replace A Cell 3
Auto Extend Formulas doesn't work for a particular formula 3
Problem searching cell text 3
format cell when a formula error occurs 5
Help with formula 4

Top