GET.NOTE

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