How do I get a line break when using a formula to combine cells

T

TESA0_4

I want to combine names and addresses into single cells, but I want a line
break so that the name is on one line and the address on the next line within
a cell. When manually entering data to a cell ALT,ENTER gives line break. I
want the formula to give the same effect as ALT,ENTER.
I'm using Excel2003.
Thanks if you can help!!
 
G

Gary''s Student

Be sure to format to allow line-wraping, then use:

=A1 & CHAR(10) & B1

in place of

=A1 & B1
 
T

TESA0_4

Great! Thanks for the help.
However, can you help with a follow-on question? Where do I go to review
what each CHAR value is and the functional effect that it has in a formula.
In other words, how can I work out that CHAR(10) has the same effect as
ALT,ENTER in a cell?
 
T

TESA0_4

Thanks David. The two links provided further insight into the CHAR function.
However, I am still interested to know where it is documented that CHAR(10)
has the effect of a line break within a cell when used in a function. I have
played around with all the CHAR values from 1 to 255 and have not detected
any other 'hidden' functions like CHAR(10). Does anyone know if there are
other CHAR values that control formating within a cell or have some other
function other than to display a character?
 
B

Beege

TESA

http://www.lookuptables.com/

THis link is a list of ASCII codes. 10 is a line feed, 13 is a carriage
return, 8 is a backspace. These are non-printing codes that I don't know
anything about, exc. the 10 and 13. They are used to control printers and
other devices. (we use 65 thru 122 all the time when we create text)

Beege
 

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

Top