In Excel, I have a large 'raw' data sheet with text cells and another sheet that shows a subset of the raw data organized differently, using 'indirect' formulas - e.g.,
=INDIRECT("Data!C5"), showing the content of C5 in Data sheet (e.g., "I like dogs").
Now, while looking at such a 'derived' sheet, I want to (manually) copy part of the text that appears in a particular cell (e.g., just the word 'dogs' in the above example), and paste it somewhere else. Pressing F2 hides the referred text cell, and shows the formula (as expected) - which is not what I need.
Is there an easy way to do it? I may potentially need to do it for tens or even hundreds of cells - so, solutions like copying the entire cell content to Notepad and copy-pasting from there would be too much of an overhead.