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?
--
BRG48

[Wayne....@gat.com]

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/microsoft.public.mac.office.excel/browse_thread/thread/57d7631f44831e92/24b64f1d69c41347?lnk=gst&q=wayne+miller&rnum=12#24b64f1d69c41347

Wayne

[JE McGimpsey]

In article <5F64DA27-89E0-4BA0...@microsoft.com>,
BRGIII48 <BRGI...@discussions.microsoft.com> wrote:

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.