Hi, I've been trawling through the net with no joy. I want to find instances of text strings within a column which is no problem using the find function. However, once found, i want to replace all of the contents of the cell with just one character.
e.g. if i'm looking for "cand" and its found in a cell whose contents are " left candida albicans", i want to replace that cell with the number 1.
Any help would put my struggling excel head to rest
Thanks
Philip
Bookmarks