Results 1 to 3 of 3
Thread: Insert Hard Breaks
2009-06-18, 10:44 #1linerGuest
Unlike the thread entitled "Hard Breaks", I want to insert one. I would like to add a hard break (ALT 010 or ALT ENTER) while concatenating. I can do it if I insert a hard break in an unused cell and then include it in the concatenation:
Where cell A2 has the hard break (ALT ENTER) inserted.
Can I insert the hard break directly?
2009-06-18, 10:51 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
You can use
where Alt+Enter has been pressed at the end of the first line of the formula.
2009-06-18, 10:57 #3linerGuest
[quote name='HansV' post='780496' date='18-Jun-2009 09:51']You can use
where Alt+Enter has been pressed at the end of the first line of the formula.[/quote]
Hans: I tried every option EXCEPT that one. Sorry to bother you, and thanks for the help.
A side comment for those reading this thread: If you don't have the cell set for text wrapping, you get a square where the break goes.