I have the below VBA code that will copy the contents of a Microsoft Word table cell and paste it into an Excel cell.
Cells(x) = WorksheetFunction.Clean(.Cell(x).Range.Text)
It works apart from picking up line breaks. So if the Word table cell reads
I was wondering whether it's possible to insert line breaks into a text box's text linked via formula to a cell.
Cell A1: "Hello, pleased to meet you. I'd like to buy an apple"
text box: =A1 -> text box displays the following with no line breaks
[ Hello, pleased to...
In 2003 Conditional Format would format (font) the whole cell. It appears that 2010 stops the formatting after a linefeed? Is this right? ie. is it my configuration/system? Is it configurable? Is there a workaround? Thanks very much.
On a PC, in the Find/Replace menu, I can add line breaks using Alt + 0010 or Ctrl + J on a laptop. What is the equivalent on a Mac? Option + 0010, Option + 0013, Apple key + 0010, Apple key + 0013 all don't seem to work.