LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Btibert
 
Posts: n/a
Default Extract Comments and paste as values


Hello all,

Hopefully there is a quick and easy answer to this question, but here
it goes. Some cells in our Excel worksheet have comments. What we
would like to do is take the "text" that is in the comment and extract
it to its own cell.

For example, if Cell B1 has "verify address" as its comment, we would
like the value of cell C1 to be _verify_address_. Simply put, we want
to take the information that is in the comment and place that in its own
cell.

Is there an easy way to do this?

Thank you in advance!!

~Brock


--
Btibert
------------------------------------------------------------------------
Btibert's Profile: http://www.excelforum.com/member.php...fo&userid=8559
View this thread: http://www.excelforum.com/showthread...hreadid=472175

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why wont my comments copy from 1 workbook to another?? LilLiz Excel Discussion (Misc queries) 6 May 3rd 07 01:23 AM
Comments LilLiz Excel Discussion (Misc queries) 2 April 2nd 05 12:18 AM
Paste Link - Cell Comments get lost Wayne H Excel Worksheet Functions 2 February 26th 05 11:51 PM
How do I export comments into another excel column as cell content Hernan Excel Worksheet Functions 1 February 25th 05 02:17 PM
I need a macro to find cut and paste data to new cell Rex Excel Discussion (Misc queries) 0 December 6th 04 12:45 AM


All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"