Help with CONCATENATE and ALT ENTER

B

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

JE McGimpsey

BRGIII48 said:
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?
Click to expand...

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.
 
Top