Hello -

I have a spreadsheet with cells that have entries separated by
Alt-Enter. Is there a way to use the Range.Replace() function to only
find entire "rows" within that cell?

Here is an example of a single cell ...
XXX_ABC.vb
YYY_CDE.xls

If I do a find of "ABC.vb" for instance, I do not want to find anything
in such a cell because it is only a partial "row".

I cannot break this into multiple cells and I have also written a
routine to step through each cell and identify entire names. The
problem is that this is very slow and the Range.Replace() is so much
faster.

Thanks,
Joe