Re: merge 3 different cells
- From: Jean Bréfort <jean brefort normalesup org>
- To: Tawee Laoitichote <astpspd pea co th>
- Cc: gnumeric-list gnome org
- Subject: Re: merge 3 different cells
- Date: Fri, 29 Feb 2008 08:22:00 +0100
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]