You could make a loop through these cells, and use Like to test whether the
cells match some kind of pattern. See in the helpfiles for the wildcards you
can use.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Paul" wrote:

Without delving into VBA (I have limited experience, and now is not
the time to learn), and without installing augmentation software, is
it possible to search for all text matching a search pattern, then
prepend each occurance with given sequence of characters?

If not, is it possible to simply prepend a given sequence of
characters the string in each cell of a selected region?

Thanks.