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.

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.

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.