troubleshooting Question

Need a Macro to extract embedded EXCEL comments

Avatar of vpopper
vpopperFlag for United States of America asked on
Spreadsheets
4 Comments1 Solution166 ViewsLast Modified:
I have three colomns of EXCEL data - one I created as a unique line ID.  The next column contains the word VOID but there is a different embedded comment in each sell. I need to extract all of these comments to the next column so that they can be analyzed. Can anyone help?  Thanks

id      "X" Confirms Complete          Extract Comment to here
29      VOID       
32      VOID      
49      VOID       
51      VOID      
86      VOID       
88      VOID      
97      VOID      
98      VOID      
104      VOID      
107      VOID      
134      VOID      
137      VOID      
153      VOID      
155      VOID      
178      VOID      
179      VOID      
183      VOID      
193      VOID      
203      VOID      
222      VOID      
242      VOID      
244      VOID      
245      VOID      
246      VOID      
248      VOID      
255      VOID      
262      VOID
ASKER CERTIFIED SOLUTION
Ejgil Hedegaard

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros