find a requested character string within a comment

Copper Contributor

Does Excel 2016 offer a way to find the line within a cell comment containing a requested string?

Some of my comments are quite lengthy and though Excel easily finds my requested string within a cell comment, it is tedious to search for the line within the comment that contains my requested string.

If Excel does not natively offer this feature, is there a macro available that I can use?

Thanks,
Dan

0 Replies