| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text and formula in the same cell - how do I format this cell?? | Excel Discussion (Misc queries) | |||
| Excel Formula if cell is empty then no if text in cell then yes | Excel Worksheet Functions | |||
| text and formula within the same cell | Excel Worksheet Functions | |||
| Can you have a formula followed by text all in one cell? | Excel Discussion (Misc queries) | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
Linear Mode
