I need to figure out a way to search a range of cells for "comments=". The
problem is that there are people's comments after the equals sign so the cell
may contain the text string with other text.

I then need to be able to remove the text string "comments=" and put the
remaining results into a different cell.

This one has really thrown me for a loop. The comments could be in any
column A through K. I can't even figure out how to find cells that CONTAIN
"comments=", everything I have tried has required an exact match of the
entire cell . If anyone could help I would really appreciate it.