| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find certain text and display it
Errata to earlier formula (pasted the formula for B6, instead of B2)
.. try instead in B2, array-entered: =IF(ISNA(MATCH(TRUE,ISNUMBER(FIND(E$2:E$6,A2)),0)) ,"",TRIM(INDEX(E$2:E$6,MATCH(TRUE,ISNUMBER(FIND(E$ 2:E$6,A2)),0)))) The above presumes that the strings searched for are always "embedded" within the source cells with a leading space (as per your original post's sample). If that may not always be the case, just amend the source by inserting a leading space as the 1st character in all source cells. In an empty col, say in H2: =" "&A2 Copy H2 down, then copy col H and overwrite col A -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find max # and display name | Excel Discussion (Misc queries) | |||
| When I wrap text, excel hides the text display | Excel Discussion (Misc queries) | |||
| HOW? Find and display the last cell in a column with a value 0 | Excel Discussion (Misc queries) | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
| trying to find how to display worksheet name in cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
