| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need of Excel Formula
Can u help me out?
In the below example you can see there are person names with their ID. So can you suggest formula in excel by which i can get only person names in a cell e.g. William Henry only. Willam Henry :ID AZ_WILHEN Robert Patricia :ID AZ_ROBPAT Gomzy Parker :ID AZ_GOMPAR I am confuse how to ignore data which is appearing from ":ID " Awaiting for Your reply and mail me on my ID only Thanks, Gaus Shaikh |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need of Excel Formula
With your first example in A1, use this:
=LEFT(A1,FIND(":",A1,1)-2) HTH Jim "GAUS" wrote: Can u help me out? In the below example you can see there are person names with their ID. So can you suggest formula in excel by which i can get only person names in a cell e.g. William Henry only. Willam Henry :ID AZ_WILHEN Robert Patricia :ID AZ_ROBPAT Gomzy Parker :ID AZ_GOMPAR I am confuse how to ignore data which is appearing from ":ID " Awaiting for Your reply and mail me on my ID only Thanks, Gaus Shaikh |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need of Excel Formula
=LEFT(K3,FIND(":",K3)-1)
-- Don Guillett Microsoft MVP Excel SalesAid Software "GAUS" wrote in message ... Can u help me out? In the below example you can see there are person names with their ID. So can you suggest formula in excel by which i can get only person names in a cell e.g. William Henry only. Willam Henry :ID AZ_WILHEN Robert Patricia :ID AZ_ROBPAT Gomzy Parker :ID AZ_GOMPAR I am confuse how to ignore data which is appearing from ":ID " Awaiting for Your reply and mail me on my ID only Thanks, Gaus Shaikh |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need of Excel Formula
On the off chance that the name can be followed by either no or many spaces
before the colon... =TRIM(LEFT(A1,FIND(":",A1)-1)) Rick "GAUS" wrote in message ... Can u help me out? In the below example you can see there are person names with their ID. So can you suggest formula in excel by which i can get only person names in a cell e.g. William Henry only. Willam Henry :ID AZ_WILHEN Robert Patricia :ID AZ_ROBPAT Gomzy Parker :ID AZ_GOMPAR I am confuse how to ignore data which is appearing from ":ID " Awaiting for Your reply and mail me on my ID only Thanks, Gaus Shaikh |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need of Excel Formula
How about DataText to ColumnsDelimited byOther.........enter a colon and Next
Select the second column and "Do not import" and Finish. Gord Dibben MS Excel MVP On Wed, 9 Apr 2008 09:11:00 -0700, GAUS wrote: Can u help me out? In the below example you can see there are person names with their ID. So can you suggest formula in excel by which i can get only person names in a cell e.g. William Henry only. Willam Henry :ID AZ_WILHEN Robert Patricia :ID AZ_ROBPAT Gomzy Parker :ID AZ_GOMPAR I am confuse how to ignore data which is appearing from ":ID " Awaiting for Your reply and mail me on my ID only Thanks, Gaus Shaikh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
Hybrid Mode
