For Background, I have a cell that reads: "The Prescription Model for Exterior Applications etc...." when I go to alter the character in the cell (to delete or add content) I can change the formatting of the text. I.e. I can change the font, size, color etc., without altering the other characters within that same cell.

So, my question is, can we create a macro that will allow the user to change/alter a selection of text from within a cell BUT WHICH DOES NOT CHANGE/ALTER other information in that cell?

Here's an example of what I'm talking about

"The Prescription Model for Exterior Applications etc..." (I want to change/alter as follows

"The Prescription Model for Exterior Applications etc..."

is this possible? I've tried for days, but I cannot figure this one out. I've probably thought myself into a corner on this one. Please help.

Thank you in advance!