View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default concatenate, char(10), and double quotes

A1=hello, A2=world

Both of the following formulas:
=concatenate(A1,char(10),A2)
=A1&char(10)&A2
return

"hello
world"

when pasted into a text file. Is there a way to get rid of the double
quotes? For what it's worth, char(13) gives the same results.

TIA.