Is it correct that cells only show 250 characters? I need a macro that will
copy all the contents of a cell and paste into a comment so the users can
read the entire block of information by hovering over the cell. I then need
this to be done automatically to each and every cell with text. I then need
the macro to update all cells and comments automatically once the cell has
been edited.

Does this make sense? Please help.