Regular expression search/replace in Excel
This formula might work in your situation. B5 being the cell to analyse,
"There" being the text you are looking for and "Hello" as the text to prepend.
Find is case sensative.
=IF(ISERR(FIND("There",B5)),B5,"Hello " & B5)
Tom
"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.
|