I have a sheet containing thousands of cells in a column. These cell contains names of different securities.
Some names of these securities contains a particular string such as "C/O".
How can I use a formula that will return the rows that have these characters?
EG. S&P 500 C/O 30/03/12 1380 MICROSOFT C/O 19/05/12 32 QUICKSILVER C/O 17/03/12 9
There is no consistency (can't use left/right/mid formula).
Requirement : I want the formula which will return "C/O" in the other cell if this particular cell contains it.