Applying a name change to existing comments in an Excel 2007 spreadsheet
I have inserted comments into cells of an Excel 2007 spreadsheet using "right click mouse > insert comment ". When I hover the cursor over a cell with a comment, a message appears in the "task bar" (not sure this is the correct name for it) at the bottom of the page. The message says, for example, "Cell E7 commented by JD". I want to expand the initials "JD" to a name and apply the change to all the comments I have already entered.
I selected the options, "round MS button at top left of page > Excel Options > Popular > User Name ". The last option is under the heading " Personalize your copy of Microsoft Office". I changed "JD" to "John". This has become the name that new comments are attributed to but the old comments are still attributed to "JD".
Is there a way I can apply the name change to comments entered before the change was made?
I would be grateful for any help on this.