Excel: Replacing Text in Cell NotesID: Q78644
|
Microsoft Excel version 3.0 does not have a menu command to perform global search and replace operations on cell notes. Choosing Replace from the Formula menu only searches cell contents, not cell notes.
To replace all instances of a portion of text with another portion of
text in cell notes, enter the following steps in a macro sheet:
A1: Replace.notes
A2: =INPUT("Replace What?",2)
A3: =INPUT("Replace With?",2)
A4: =IF(NOT(AND(A2,A3)),RETURN())
A5: =FOR.CELL("current")
A6: =NOTE(SUBSTITUTE(GET.NOTE(current),A2,A3))
A7: =NEXT()
A8: =RETURN()
Additional query words:
Keywords :
Version :
Platform :
Issue type :
Last Reviewed: March 23, 1999