I'm trying to use the CONCATENATE function but I also want to force a
'return' in the function/formula as if entering data into a cell and using
ALT+ENTER to force a new line. Can this be done?

You can use CHAR(10) in your Concatenate function, like this:
=CONCATENATE("First line",CHAR(10),"Second line")

You also need to format the cell to allow text wrapping, or the linefeed
character will appear as a little square box.

Hope this helps,

Hutch

"JeffRI" wrote:

> I'm trying to use the CONCATENATE function but I also want to force a
> 'return' in the function/formula as if entering data into a cell and using
> ALT+ENTER to force a new line. Can this be done?

This was awesome!! Thx for the info! That's exactly what I was looking for.

"Tom Hutchins" wrote:

> You can use CHAR(10) in your Concatenate function, like this:
> =CONCATENATE("First line",CHAR(10),"Second line")
>
> You also need to format the cell to allow text wrapping, or the linefeed
> character will appear as a little square box.
>
> Hope this helps,
>
> Hutch
>
> "JeffRI" wrote:
>
> > I'm trying to use the CONCATENATE function but I also want to force a
> > 'return' in the function/formula as if entering data into a cell and using
> > ALT+ENTER to force a new line. Can this be done?

You can also use ="Line1" & CHAR(10) & "Line2"
CONCATENATE is such a long way of saying &.
You must format the cell to wrap text.

Tyro

"JeffRI" <(E-Mail Removed)> wrote in message
news:671596E3-1186-4D33-8913-(E-Mail Removed)...
> I'm trying to use the CONCATENATE function but I also want to force a
> 'return' in the function/formula as if entering data into a cell and using
> ALT+ENTER to force a new line. Can this be done?

[gamut]

If you need to do this on Mac, there is a silly way to achieve it. Basically, you need to put an actual newline inside quotes. Like so:
=A1 & "
" & B2

To put a newline in there, press Ctrl-Alt-Enter