Is there a way to find certain text inside comments of cells?
What I'm looking to do is to search through a column of cells and only
look for text inside the comments that are placed in the cells IF there
are comments in those cells to begin with. So:

1. Find cells with comments
2. Find certain string of text within that comment
3. Take the number in front of the text and use that number to add to
the next number that will be found in the next string found

Example:
Comment in C1: "*1* V. Term."
Comment in C3: "*3* V. Term."

Cell D1: (*1* + *3*) = *4*


--
malik641
------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=383904