AmericanSeiko
New Member
- Joined
- Sep 16, 2013
- Messages
- 21
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!![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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!