Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to search cell to see if it Contains a value.
Have a spreadsheet output from a active directory query.
One cell in the spreadsheet contains all the various permission groups a user is a member of (i.e., Group1, Group5, Group6). I want to search that cell for a specific Group and move that value to an empty cell. It doesn't seem that Excel has an expression for 'Contains' but can only evaluate on 'Equal to'. The cell will definitely contain additional groups so = will not work. Past experience with a different spreadsheet software allowed looking at the contents of a cell and evaluating based on it containing or not containing a specific text string. I can't seem to accept that Excel doesn't do that. I'm frozen in time. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to search cell to see if it Contains a value.
Hi
try something like =IF(ISNUMBER(FIND("Group1",A1)),"cotains group1","does not contain group1") -- Regards Frank Kabel Frankfurt, Germany BAM wrote: Have a spreadsheet output from a active directory query. One cell in the spreadsheet contains all the various permission groups a user is a member of (i.e., Group1, Group5, Group6). I want to search that cell for a specific Group and move that value to an empty cell. It doesn't seem that Excel has an expression for 'Contains' but can only evaluate on 'Equal to'. The cell will definitely contain additional groups so = will not work. Past experience with a different spreadsheet software allowed looking at the contents of a cell and evaluating based on it containing or not containing a specific text string. I can't seem to accept that Excel doesn't do that. I'm frozen in time. Any help would be appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to search cell to see if it Contains a value.
If you mean in VBA, lookup the Like operator in help.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi try something like =IF(ISNUMBER(FIND("Group1",A1)),"cotains group1","does not contain group1") -- Regards Frank Kabel Frankfurt, Germany BAM wrote: Have a spreadsheet output from a active directory query. One cell in the spreadsheet contains all the various permission groups a user is a member of (i.e., Group1, Group5, Group6). I want to search that cell for a specific Group and move that value to an empty cell. It doesn't seem that Excel has an expression for 'Contains' but can only evaluate on 'Equal to'. The cell will definitely contain additional groups so = will not work. Past experience with a different spreadsheet software allowed looking at the contents of a cell and evaluating based on it containing or not containing a specific text string. I can't seem to accept that Excel doesn't do that. I'm frozen in time. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i make a cell a search cell for a spreadsheet | Excel Worksheet Functions | |||
Formula to Search one specific cell on another sheet. | Excel Discussion (Misc queries) | |||
copy a cell value based on search of another cell | Excel Worksheet Functions | |||
FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
format cell to search text in another cell | Excel Discussion (Misc queries) |