I am trying to combine a few cells of text into one which includes a line break. Is there a symbol I can use as part of my formula that will generate the line break?
Let's say cell A1 was "John", cell B1 "Doe", and cell C1 "25 years" and I wanted to combine them in a new cell in the following format:
John Doe
25 years
by formula
=A1&" "&B2&"<line break symbol>"&C1
where <line break symbol> is what I am looking for
Hi,
try
=A1&" "&B2&CHAR(10)&C1
don't forget to set the cell to wrap text and make the rows high enough to see all lines!!
In my standard template, I have a defined formula vbLf =CHAR(10) for just that purpose; then you can do =A1 & vbLf & B2 & vbLf & C1
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks