| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export cell comment as a data cell
I am importing Excel data into an Access database. Is it possible to put
cell comments into a column of their own? I need both the field data and the comments. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export cell comment as a data cell
hi
see debra dalgleish's site - copy comment to adjacent cell. http://www.contextures.com/xlcomment...l#CopyAdjacent regards FSt1 "KADL" wrote: I am importing Excel data into an Access database. Is it possible to put cell comments into a column of their own? I need both the field data and the comments. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export cell comment as a data cell
You can use this macro found at Debra Dalgleish's site to extract the comments'
contents to an adjacent column. http://www.contextures.com/xlcomment...l#CopyAdjacent Gord Dibben MS Excel MVP On Mon, 5 Nov 2007 15:31:27 -0800, KADL wrote: I am importing Excel data into an Access database. Is it possible to put cell comments into a column of their own? I need both the field data and the comments. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Export data in cell as the subject line in an email | Excel Worksheet Functions | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| Create Cell Comment based on text in a cell on another worksheet | Excel Discussion (Misc queries) | |||
| Can I do conditional formula based on data in cell comment? | Excel Discussion (Misc queries) | |||
| I want to change comment printing cell 3 to whats in cell 3 | Excel Worksheet Functions | |||
Linear Mode
