Line breaks in text boxes linked to cell

[AmericanSeiko]

Hi everyone,

I was wondering whether it's possible to insert line breaks into a text box's text linked via formula to a cell.

For example,

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 meet you. I'd like to buy an apple. Thank you. ]

I'd like to force line breaks to make the text box display like this:

[ Hello, pleased to meet you.]
[ I'd like to buy an apple.]
[ Thank you.]

Is this possible? Unfortunately, I can't simply hit "enter" as one normally would. If not, I can define three distinct text boxes for each line, but doing so makes reformatting inefficient. Thank you in advance for your help!

 

[NeonRedSharpie]

[COLOR=#333333]="Hello, pleased to meet you." & CHAR(10) & "I'd like to buy an apple." & CHAR(10) & "Thank you."[/COLOR]

char(10) is excel code for line break.

 

[AmericanSeiko]

So simple, exactly what I was looking for. Thanks so much!