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. |
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) |