Convert comments into own column

[Ellen]

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

Thanks in advance,
Ellen

 

[Frank Kabel]

Hi
only possible with VBA and a user defined function

 

[Frank Kabel]

Hi
for a UDF try 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

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

 

[Ellen]

The script it beautiful! Many thanks!!

-----Original Message-----
Hi
for a UDF try 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

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

--
Regards
Frank Kabel
Frankfurt, Germany



.