ExcelBanter - how insert the return key in formulas for concatenate of text?

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

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

- - how insert the return key in formulas for concatenate of text? (https://www.excelbanter.com/excel-discussion-misc-queries/180445-how-insert-return-key-formulas-concatenate-text.html)

~0-0~

how insert the return key in formulas for concatenate of text?

How do I write a formula to concatenate text columns that will allow me to
see different lines of combined text in excel 2003 formulas. I'm trying to
use one column for a barcode software to make badges for a conferrence

Gary''s Student

how insert the return key in formulas for concatenate of text?

ALT-ENTER
--
Gary''s Student - gsnu200774

"~0-0~" wrote:

How do I write a formula to concatenate text columns that will allow me to
see different lines of combined text in excel 2003 formulas. I'm trying to
use one column for a barcode software to make badges for a conferrence

Gord Dibben

how insert the return key in formulas for concatenate of text?

=A1 & CHAR(10) & B1 & CHAR(10) & C1

Gord Dibben MS Excel MVP

On Tue, 18 Mar 2008 08:27:00 -0700, ~0-0~
wrote:

How do I write a formula to concatenate text columns that will allow me to
see different lines of combined text in excel 2003 formulas. I'm trying to
use one column for a barcode software to make badges for a conferrence

All times are GMT +1. The time now is 02:51 AM.