![]() See screenshot:Ĭonvert comments to cell contents with VBA code And all of the comments are converted to cell contents. And select cell E1, then drag the fill handle over the range of cells that you want to contain this formula. ![]() You can finish it as the following steps:ġ.Click Developer > Visual Basic, a new Microsoft Visual Basic for applications window will be displayed, click Insert > Module, and input the following function into the Module: Function GetComments(pRng As Range) As Stringģ.Then input the following formula “ =GetComments(A1 )” in any blank cell, in this case, I will use cell E1. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!īy using this method, you need to create a defined function first, and then apply the defined formula to convert the comments to cell contents.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |