Selective Text Replacement

[Doug Hinahara]

I want to have selected text within a text string in a cell, be
automatically replaced with selected text from another cell, after that
text is entered. Can this be done?

 

[Don Guillett]

Do you mean something like this where d3 has xxxxx
=111&D3&222
to get 111xxxxx2222