Re: merge 3 different cells




Le vendredi 29 février 2008 à 14:01 +0700, Tawee Laoitichote a écrit :
Dear,

I can not find command to do merging 3 different cells, such as ; _29_   
_/03_  _/2008_     to be   _29/03/2008_  .
Since, I've got the text converting result from pdf file and I want to 
process in xls of gnumeric readable.
Thanks.

You might use the "concatenate" sheet function if you want it as a
string, ab, if you wish the value:
=value(concatenate("29","/03","/2008"))

Hope this helps

Jean




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]