Then you have to let us know what they are!
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Paul" wrote in message
...
Multiple strings.

On Jul 31, 11:08 am, "RagDyeR" wrote:
Exactly *what* cells are you looking for?

Is it one specific text string or number, or multiple ones?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Paul" wrote in message

...
Yes, that is what I meant in my first paragraph. RD's solution help
if I want to manually go through and find these cells myself.

On Jul 29, 11:24 pm, "RagDyer" wrote:

In re-reading your OP, are you looking to ... say ...
add that "P.O. #" text to *only certain* cells that might contain a
specific
text string?

If you're still looking for help in that vein, post back with some
specifics.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
!
---------------------------------------------------------------------------"Paul"
wrote in message

...

On Jul 27, 4:19 pm, "Ragdyer" wrote:
Is this something you're looking for:

Text in A2 to An.

To insert the text:
P.O. #
at the beginning of each cell.

In A1 enter:
P.O. #

Enter this formula anywhe

=A$1&" "&A2
And copy down as needed.

--
HTH,

RD

RD, that does indeed help, and fits the bill of my currently limited
Microsoft experience. Thank you!

wrote in message

...

Tom,

Thanks for the code snippet. I wasn't clear in my OP, but I was
seeking a non-VBA method of search-and-replace with regular
expressions. But from the lack of responses in that vein, I'm
assuming that there isn't such a solution.

On Jul 24, 2:47 pm, TomPl wrote:
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.- Hide quoted text -

- Show quoted text -