I copy a text formula containing the control character CHAR(10) from a source workbook and 'Paste Values' same to a cell in a destination workbook. The intermediate result is a text string a) incorporating factors such as concatenation, b) but without effect being given the control character, and c) an annoying imposition of 'Word Wrap' on the destination cell. Apparent failure. But at this point the same formula result appears in the Formula Bar with effect given the control character. So Step 2 is to click anywhere in the Formula Bar, then CTRL-A and CTRL-C to select all and re-copy the results to the Clipboard. Step-3 is to again 'Paste Values' the upgraded results to the destination cell (and turn off the pesky Word Wrap feature). It is a pain double-copying and double-pasting and fiddling with Word Wrap, but it works. Excel seems to only respect the copied control character if its formula appears in the Formula Bar. No, one cannot paste the source formula directly into the Formula Bar of the destination sheet - one must double-paste.