Thread: how insert the return key in formulas for concatenate of text?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote