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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

~0-0~ - 18 Mar 2008 16:27 GMT

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

Reply to this Message

Gary''s Student - 18 Mar 2008 16:34 GMT

ALT-ENTER

Signature

Gary''s Student - gsnu200774

> 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

Reply to this Message

Gord Dibben - 18 Mar 2008 19:13 GMT

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

Gord Dibben MS Excel MVP

>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

Reply to this Message