Macro Sheets Only
Returns characters from a note.
Syntax
GET.NOTE(cell_ref, start_char, num_chars)
Cell_ref is the cell to which the note is attached. If cell_ref is omitted, the note attached to the active cell is returned.
Start_char is the number of the first character in the note to return. If start_char is omitted, it is assumed to be 1, the first character in the note.
Num_chars is the number of characters to return. Num_chars must be less than or equal to 255. If num_chars is omitted, it is assumed to be the length of the note attached to cell_ref.
Examples
The following macro formula returns the first 200 characters in the note attached to cell A3 on the active sheet:
GET.NOTE(!$A$3, 1, 200)
In Microsoft Excel for Windows, the following macro formula returns the 10th through the 39th characters of the note attached to cell C2 on SALES.XLS:
GET.NOTE("[SALES.XLS]Sheet1!R2C3", 10, 30)
In Microsoft Excel for the Macintosh, the following macro formula returns the 10th through the 39th characters of the note attached to cell C2 on SALES:
GET.NOTE("[SALES]Sheet1!R2C3", 10, 30)
Use GET.NOTE with the NOTE function to move the contents of a note to a cell or text box or to another cell note:
NOTE(GET.NOTE(!$B$10),ACTIVE.CELL())
Related Functions
GET.CELL Returns information about the specified cell
NOTE Creates or changes a cell note.
SOUND.NOTE Records or imports sound into or erases sound from cell notes
List of Information Functions