Worksheet Cell Notes and Power Query?

[IanKR1960]

Hi

Is there any way to get Power Query to pick up Excel worksheet cell Note text, or is it only cell values that it can report in a query? For example, in the attached picture, cell B2 contains "cell value" as its value and "Note text" in its Note (what used to be called a Comment, I think). Can Power Query 'read' the cell Note text and report it in a query?

[#2 · Accepted solution]

@IanKR1960 I dare to say that PQ can not do that. If the comments are important for what you need to achieve in PQ, you need to include them, each in their own cell.

[#3]

Thanks. I suspected as much. I've written VBA code that puts cell notes into cells (as cell values) in the adjacent worksheet column, prior to running a query. I'll have to stick with that!