Extract Comments to Cell and search with AutoFilter

[Barb Reinhardt]

I know how to programmatically remove comments from the comment box and put
them in a cell, however, some of these comments are very long and they don't
appear to be displayed in the cell. How can I copy them over so that they
are searchable using the Autofilter functionality? Do I need to put some Alt
Enters into the cells? FWIW, some of the comments are as long as 16000
characters.

Thanks,
Barb Reinhardt

 

[Tom Ogilvy]

I think autofilter only looks at the first 255 characters.

 

[Gord Dibben]

Barb

Tom is correct about the 255 character limit.

For workaround see Debra's site

http://www.contextures.on.ca/xlautofilter02.html#String


Gord Dibben MS Excel MVP