Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a word in a cell, but not when its a substring of another word in the cell
Hi All
I have cells in an excel spreadsheet with contents (employee short-form initials) like [tv pm dsab sa] - this is the content of a single cell. When such cells are scanned for contents equal to, say, 'ds' or 'sa' I don't want to flag on 'dsab' (which contains both 'ds' and 'sa'), but only on matches to 'ds' or to 'sa' as unique values. I've tried using Find with what:="xx " i.e. using the space between words as part of the search string, bu this fails on the last entry in the cell (above, [ ... sa] has no trailing space in the cell content so is not found There has to be a better (real) way ... cheers Derrick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make cell equal a word if a data validation cell has a word in it | Excel Discussion (Misc queries) | |||
How do a put a word on top of a word in a cell? | Excel Discussion (Misc queries) | |||
Macro for finding number of times a word repeats in a cell | Excel Programming | |||
Matching CELL text (full word) to full word in string in another | Excel Programming | |||
Add word in cell changes to word TRUE | Excel Discussion (Misc queries) |