If you input =A1 in Cell B1 excel returns the data only.
Id like to have the option to link the formatting too. Cell Colour, text colour, borders, comments...... chose one, some or all formats
Yeah, it'd be nice.
I wished formatting could be specified as an addition to formulas, and pictured a string added for doing so (With, say, square brackets to make it clearly that.)
But having a sample formatted cell somewhere, and specifying simply the formatting of that cell, would be even easier. And of course, that would work nicely for this.
Even better would be if it also brought with it internal cell formatiing, where one letter is red while the others are black, for example.
Harder would be cells that were like... LEFT(A1,3) but if it brought in-cell formatting it could format as those three characters are formatted.