comments to cells

[Geordie]

Hi All

I have a small problem and I cant post the spreadsheet on the internet

But it looks like text which was entered into a cell has now been move to comments and I just want to move them back

any ideas

Thanks in advance

[zbor]

Geordie, you don't need to post actual workbook but you can create example what you trying to do (avoiding personal informations).

[Geordie]

please find attached an example workbook

in column A i have cells A1, a2 & A3 have comments but these comments should actually be in the cell direct as shown in column B

how do I copy these over?

hope this helps

[zbor]

Does this helps:

Select cells you want to remove comments (comments will be exported in next right cell) and run macro:

Please Login or Register  to view this content.

[Geordie]

thanks that works a treat