I am trying to combine three cells into one, with Alt + Enter
or Char(10)
separating each value. When I use a simple Excel formula =B2 & Char(10) & C2 & Char(10) & D2
and wrap the text of the destination cell, everything seems normal. The actual cell value is a string of B2
, C2
, and D2
run together. Is there actually a way to have the value appear as if I manually entered First Value
Alt + Enter
Second Value
Alt + Enter
Third Value
?
2 Answers
Easy!
Once you have entered the formula and see the displayed value looks O.K., copy the cell and PasteSpecialValues back into the cell.
The formula will be gone and the contents will appear to have been entered manually!
Or you may also paste special values with source formatting and you get the desired results
You can get it to work using CHAR(13) instead of CHAR(10):
=CONCATENATE(A9&CHAR(13),A11&CHAR(13),A13)
& " " &
to your formula