Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi All
I have a hundreds cells with a long text string separated by comma's detailing the all the applications on PC as follows: Column A, Cell A2: PC Reference Column B, Cell B2: Access 2000, Project 2000, Front 2000, Easy CD Creator, Adobe 5.0, etc ....And the list continues to rows 15000 Is there a way I can search the string in B2 to identify 'Project 2000' only and then populate a blank Cell (C2) with 'Project 2000'? Something like: IF the string in Cell B2 contains 'Project 2000' THEN populate Cell C2 with 'Project 2000'. I'd appreciate any advise on how to create such a worksheet function. Thanks in advance, H |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy/Paste Rows that Contain Specific Text | Excel Worksheet Functions | |||
Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
Text String - Specific Characters | Excel Worksheet Functions | |||
Reomving a set numer of characters from a text string | Excel Discussion (Misc queries) | |||
Remove last character of text string | Excel Worksheet Functions |