ExcelBanter - How do I join text from 2 cells, and make them appear in 2 lines

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I join text from 2 cells, and make them appear in 2 lines (https://www.excelbanter.com/excel-discussion-misc-queries/151452-how-do-i-join-text-2-cells-make-them-appear-2-lines.html)

becerra

How do I join text from 2 cells, and make them appear in 2 lines

Gord Dibben

How do I join text from 2 cells, and make them appear in 2 lines

=A1&CHAR(10)&B1

Set the cell to wrap text.

Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 08:14:04 -0700, becerra
wrote:

All times are GMT +1. The time now is 07:12 PM.