Alan

in Excel, you would do a global replace of "place" by "this place". Record
a macro while you do this manually and that should give you the code that
you need.

Regards

Trevor


"AlanG" wrote in message
...
I have a text string in a cell and I want to add a new text string in front
of the existing text string in the same cell. For example, the word
"place"
is already in the cell and I want to add the word "this" in front of the
word
"place" to form a new string in the cell that is "this place". How would I
do
this in visual basic?