retrieve data entered as a note

[Kibbe]

Good afternoon,
I inherited a data sheet where all part serial numbers have been entered as a note, rather than in a cell. Is there
a way I can extract the serial numbers to a different tab, or are they not usable?
Any solution is fine.
Please see attached sheet for an example.
Thanks,
GK

[Ron Coderre]

Using your posted workbook....
Here is a starting point:
• Select your worksheet
• ALT+F11...to open the VBA editor and select your workbook from the VBA Project window
• Insert.Module...to create a new VBA module
• Copy the below code and paste it into that VBA module:

Please Login or Register  to view this content.

Now, on your worksheet, this formula, copied down, returns the comments
E3: =getcomment(C3)

In your workbook, E3 will display: help me 91066, 89740, 91234, 89558,

Is that something you can work with?