Re: merge 3 different cells

[Tawee Laoitichote <astpspd pea co th>]

Jean Br้fort wrote:
> 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
>
>
>
>   
Thanks Jean, it works.... And I've to do extra work as "copy special" to 
get the value not the formula.

Tawee