| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula
I have the following situation Cell A Abdal-Ghaffar, NadyN14264504Middle Eastern and Islamic StudiesPHD Cell B Abdal-Ghaffar, Nady how do i build a formula on cell Cell C to look up the name on the text string |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula
Assuming that string is in A2 and the name is always followed by a comma, this formula will pull out the name: =LEFT(A2,FIND(",",A2)-1) -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62747 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula
Hi Thank you so much for your help , I am still stcuk a bit I do not want to
separete the name but to look up in another cell Cell A =A bdal-Ghaffar, NadyN14264504Middle Eastern and Islamic StudiesPHD Cell B = Abdal-Ghaffar, Nady Cell C = look up B in A and return to C Thank you "JBeaucaire" wrote: Assuming that string is in A2 and the name is always followed by a comma, this formula will pull out the name: =LEFT(A2,FIND(",",A2)-1) -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62747 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula
=IF(ISERR(SEARCH(B1,A1)),"Not Found",A1) -- mdmackillop ------------------------------------------------------------------------ mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62747 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Linear Mode
