anything in Excel...

It's Excel-o-lozy...

Excel Formula to copy the Comment of one cell in another cell as text.. under formulaFix by Excelolozy.

www.Excelolozy.com - A bit typical but valid and important question.

Ever felt the need of a formula to get the "Comment" of one cell as "Text" in another cell.

Following is the Formula :

=Comment("A1")

Strange!!! No?

Yup, 

It brings the Comment of any cell or say Range "A1" as a TEXT in the another cell where the formula is entered.

This formula is miracle for them who want to apply some sort of formula based on contents of Comment of a cell.

The formula "Comment" is available within tool named "formulaFix".

"formulaFix" is a "Formula (fx) Fixing Tool" that provides various formulas that dont exist in Excel.

To download "formulaFix" click here.
  
Anything in Excel, be an Excelolozian...
for best MS Excel Tips visit http://www.Excelolozy.com
gotta query??? drop a mail at mail@excelolozy.com