Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |