Posted by Chas on February 27, 2001 7:45 PM
I hope this is not a duplicate request as I could not find one similar. I have a sheet with several thousand rows. In one column, about half of the cells have comments attached. We are in need of transfering the data to a Access DB and at this point we will lose all data that has been entered into a comment. I am thinking there must be a way of copying the data in a comment to an adjacent cell so that we may save that data for the DB.
Any help is greatly appreciated.