=?iso-8859-1?B?UmU6IENPTkNBVEVOQVRFIGZ1bmN0aW9u?=

[Avik Sengupta]

try 

CONCATENATE("String","String")

that works, i just tested it. I'll send u the testcase if u want!


Of course, remember to escape the strings if u write the above as a java string 
literal. 



   -------Original Message-------
   > From: Jean, Victor [IT] <[EMAIL PROTECTED]>
   > Subject: CONCATENATE function
   > Sent: 10 Oct 2003 00:11:41
   >
   >  I'm trying to use the
   >  
   >  CONCATENATE("String":"String")
   >  
   >  function to combine two different strings.
   >  However, it seems that POI does not recognize the concatenate formula in a
   >  cell.
   >  
   >  I get a "Error: Name Expected" message.
   >  
   >  Does anyone know of a patch, fix,  or version of POI which contains
   >  the concatenate function?
   >  
   >  Thanks,
   >  
   >  Victor
   >  
   >  ---------------------------------------------------------------------
   >  To unsubscribe, e-mail: [EMAIL PROTECTED]
   >  For additional commands, e-mail: [EMAIL PROTECTED]
   -------Original Message-------