|Sorry still don't understand what your trying to do.|
Please understand that I can not see your worksheet from where I'm sitting,
so you have to explain everything in detail, using Column Letters and Row Numbers.
and describe what it looks like before and what you want it do look like after.
It would be helpful if you would post a short example of your spread sheet.
I've taken to using find a replace but I'm sure there's an easier way.
There are formulas that can do a search,
and there are formula that can do a replace
but they each require another cell to work with.
In other words in Cell A1 you have the text string:
1) Name_ is going to the _____
and you want to replace the string Name, in cell A1 you can't do it.
You would need to place a formula in cell B1 such as:
Then cell B1 would look like:
1) Name_ is going to the _____ Rohl_ is going to the _____
Changing the contents of cell A1, in place, requires the Search/Replace function on the task bar, or a short macro.