Line Feed within String Formula (Not Manual or VBA)

[Barbarr]

Okay, I know how to manual line feed within a cell (Alt+Enter) and I know how to do with the code.

What I'm after is a line feed within a cell using a string formula, for example:

=A2 & chr(10) & B2 & chr(10) & C2

[norie]

Do you mean on a worksheet?

This should work if you turn on word wrap in the cell with the formula.

=A2 & CHAR(10) & B2 & CHAR(10) & C2

[Barbarr]

=A2 & CHAR(10) & B2 & CHAR(10) & C2

Yeppers, that works -- just 1 little letter more than in VBA's chr(10), duh!

Thanks Norie.