Force line break in label that is concatenated

[General Ledger]

Dear All,

I have a cell where I am stringing text together and want to force a line break/carriage return in the label. I know that if I was purely entering text, I can hit ALT+Enter within the text to force a line break. How do I accomplish this when the text is created using concatenation (strung together using &)?

I am concatenating text plus a cell reference. This formula gets me the correct wording in cell A2: = "Total" & A1

I want to force a line break between the word Total and the value from cell A1. I thought the solution was inserting the ASCII code for a carriage return. Something like this in cell A2: = "Total" & Char(13) & A1

This seems to place a | within the label and is not what I was hoping for.

Yes, the cell is formatted with Wrap Text checked on.

I am using Excel 2003.

Best regards,

General Ledger

 

[Andrew Poulsom]

It's CHAR(10) and you need to set Wrap text.

 

[VoG]

Try

= "Total "&CHAR(10)&A1

 

[General Ledger]

That is it!!! I was using the wrong code.

I used Char(13) which is carriage return
I should use Char(10) which is line feed/new line

Thanks so much for the very speedy help,

GL