Try this:

Select the range to be impacted

From the Excel main menu:
<edit<find
Find what: xxx
Click the [options] button
Look in: Comments
Click the [Find all] button

While the list of matching cells is displayed....
Hold down the [Ctrl] key and press A
(that will select all of the matching cells)

If you need those cells to all have the same value....eg 123:
Type 123
Hold down the [Ctrl] key and press [enter]
(instead of just pressing [enter] )

Does that help?
***********
Regards,
Ron

XL2002, WinXP


" wrote:

Hi. I've searched through previous posts, and it seems that none is
what I am looking for. Everyone else seems to want to find cells with
specific text in the comment and replace that text within the comments.
What I need is to find all cells with specific text in the comments,
then replace the cell values. "Find all cells with "xxx" in the
comments and change all of the cell values to "123". I'd do it one by
one but there are hundreds. None of my macros seem to work. Any
ideas?

Thanks.
Kind regards,