Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to CONCATENATE 50 fields in Excel table into SQL Insert State | Excel Discussion (Misc queries) | |||
How do I insert a line break (carriage return) in text in a cell? | Excel Discussion (Misc queries) | |||
Using concatenate to include a line return | Excel Discussion (Misc queries) | |||
How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
How do I insert a line break when using the CONCATENATE function? | Excel Worksheet Functions |