Forcing a line feed in the middle of a string

  • Thread starter Thread starter dhstein
  • Start date Start date
D

dhstein

I have a cell like this:
=AT4&" "&AU4&" "&AT5&" "&AU5&" "&AT6&" "&AU6

This concatenates some text in a cell. I'd like to force a line feed after
the 2nd and 4th parameter for formatting purposes. I tried & char(13) & but
that didn't work. I appreciate any help on this.
 
I usually just insert:
&"{Alt+Enter}"&

just for clarity you press Alt+Enter and not type it there.
Make sure that the cell that has this formula is formatted as Wrap Text (in
format cell).
 
Try chr(10) and make sure you set the format to wrap text--else you'll see a
little square in your cell.

=at4&chr(10)&...
 
AB, Dave,

Thanks.



Dave Peterson said:
Try chr(10) and make sure you set the format to wrap text--else you'll see a
little square in your cell.

=at4&chr(10)&...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fonts & Line Feed in a Cell 4
Forcing a line feed in a text cell? 2
How can I insert a line feed in the text in an EXCEL cell? 2
How to ADD a line-feed or BREAK to Chart Title? 6
ALT-ENTER in a concatenate formula 2
Inserting mulitpul Text and a Tab Symbol into a cell 0
line feed not showing in report 4
Line Feed in Formula Bar 1

Back
Top