Excel 2007 : adding newlines to concatenated text

[jimredfield]

I am concatenating text elements that together generate a very long string. I'd like to insert newlines in the formula to 'break' the text to a new line or paragraph at various points. Is there a code element I can insert in the concat formula to do this? Seems like VBA would be overkill for this.

Thanks for your help. - Jim

[Søren Larsen]

I'm not sure this what you are looking for, but CHAR(10) adds a line-break in a text string. If for example you put the following in a cell and format it with "Wrap Text":

="My first string"&CHAR(10)&"My second string" then in the cell it will show as:

My first string
My second string

[jimredfield]

Thanks Søren, that's what I needed. Could I trouble you for the CHAR( ) code for a tab? ...for that matter, where can I find the list of CHAR codes that Excel 7 recognizes? - Jim

[Søren Larsen]

Here's a list of =CHAR() codes:

http://www.petefreitag.com/cheatsheets/ascii-codes/

You will see that TAB is =CHAR(9), but for some reason it won't work. Did a quick google, and it seems that using a TAB in a string of text inside a cell is not possible.

[jimredfield]

Thanks again! - Jim

[Søren Larsen]

You're welcome!