ExcelBanter - EXCEL 2003: how to add CR or alt-enter using CONCATINATE function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - EXCEL 2003: how to add CR or alt-enter using CONCATINATE function (https://www.excelbanter.com/excel-programming/360767-excel-2003-how-add-cr-alt-enter-using-concatinate-function.html)

MRHenn

EXCEL 2003: how to add CR or alt-enter using CONCATINATE function

i am trying to insert a carriage return or alt-enter in a cell in the
CONCATINATE function. CONCATINATE(a1, "-", b1, "(enter)") where enter is
the symbol i need to use. do not know what it is so it will force an CR or
alt-enter.

Dave Peterson

EXCEL 2003: how to add CR or alt-enter using CONCATINATE function

char(10)

=concatenate(a1,"-",b1,char(10))
or
=a1&"-"&b1&char(10)

MRHenn wrote:

i am trying to insert a carriage return or alt-enter in a cell in the
CONCATINATE function. CONCATINATE(a1, "-", b1, "(enter)") where enter is
the symbol i need to use. do not know what it is so it will force an CR or
alt-enter.

--

Dave Peterson

All times are GMT +1. The time now is 01:24 PM.