Help with CONCATENATE and ALT ENTER

[BRGIII48]

I’m trying to use the CONTATENATE formula to create a mailing address from a
database. The problem I’m having is that I need to put the name on one line
and the address and a separate line within the same cell. What is the best
way to accomplish this? Can ALT ENTER be used in the CONCATENATE FORMULA?

 

[JE McGimpsey]

I’m trying to use the CONTATENATE formula to create a mailing address from a
database. The problem I’m having is that I need to put the name on one line
and the address and a separate line within the same cell. What is the best
way to accomplish this? Can ALT ENTER be used in the CONCATENATE FORMULA?

In MacXL the keyboard shortcut is CTRL-OPT-ENTER. To use in a formula,
use CHAR(13), e.g.:

="line 1 text" & CHAR(13) & "line 2 text"

or equivalently:

=CONCATENATE("line 1 text", CHAR(13), "line 2 text")


Make sure that the cell is set to wrap text.

 

[Wayne.Miller]

Use CHAR(13) to get a line break within the CONTATENATE function.
However, this works only for Mac users. If PC users will also use the
spreadsheet, go to this previous thread:
http://groups.google.com/group/micr...k=gst&q=wayne+miller&rnum=12#24b64f1d69c41347

Wayne