Hello,

I have an Excel spreadsheet that has a column of cells
with lots of comments. I'd like those comments in their
own field. My goal is to convert this spreadsheet to an
Access table.

In an earlier post I was told that only possible with VBA
and a user defined function with the following:

public function get_comment(rng as range)
dim res
on error resume next
res=rng.comment.text
on error goto 0
get_comment=res
end function

Then use the following formula on your worksheet:
=GET_COMMENT(A1)

Can someone descrite to me how to create the user defined
function?

Thank you in advance.

Ellen