I have a sheet with 200 rows and every cell has a comment. The information I need is in the comments. Is there a way to pull the information out of the comment and put the values into the adjacent cell?
Thanks in advance,
Kind of a lot of gray area as to what exactly you're doing but perhaps this will
give you a start.
If you intend to use vba and if by 'adjacent cell' you mean the next cell to the right
then something like this should help.