Extract comments (Not notes) from excel

IamLost

New Member
Joined
Jan 8, 2013
Messages
16
Hello, I have looked through the search and cant find anything, also google is not helping. I have inherited an excel spreadsheet which has a lot of data as well as a lot of comments. I am looking for a way to extract the comment into a new cell. Everything I read online refers to the "old" comments which are now called Notes I believe.

To simplify, I have a spreadsheet with for e.g. Column A has information in the cell as well as a comment. What I want to be able to do is run a macro to extract or copy the information in the comment and paste this in the cell to the right.

Any help would be much appreciated.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,301
Office Version
  1. 365
Platform
  1. Windows
When you try the code does it work on your version?
Yup, the L3 is just a single comment & N7 has a reply.
1607957074129.png
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
17,403
Office Version
  1. 2013
Platform
  1. Windows
Thumbs up as a thank you and works for the Nots not comments.
Well my script was written for comments not Notes. I use Excel 2013 and am not familiar with Notes. So it's surprising my script works for Notes but not comments.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,301
Office Version
  1. 365
Platform
  1. Windows
@My Aswer Is This
The Comments you are referring are now called Notes (from 2016 onwards), which is why your code worked for them. What are now called Comments are something completely different.
 

IamLost

New Member
Joined
Jan 8, 2013
Messages
16
Well my script was written for comments not Notes. I use Excel 2013 and am not familiar with Notes. So it's surprising my script works for Notes but not comments.
There is obviously a bit of confusion, but as explained by Fluff.

Older versions of Excel called them Comments, These are now called Notes - This is what your code works on
In new versions of Excel, they created a new feature and called them comments. These are NOT the same as the old comments, but a new feature where you comment and respond on comments.
 

Zot

Well-known Member
Joined
Nov 26, 2020
Messages
965
Office Version
  1. 2016
Platform
  1. Windows

Watch MrExcel Video

Forum statistics

Threads
1,127,107
Messages
5,622,782
Members
415,927
Latest member
vedasinternational

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top