Re: zase EXCEL -zlucenie stlpcov

From: Petr Pokorny <mail (zavinac)>
Date: 05. 05. 2005, 10:43 CEST
AleX <faklabrejle@gmail.com>:

> v bunke kde chces mat zlucene bunky napis:
> = A1 & " " & A2
> ta medzera (uvodzovky) medzi hodnotami je len optional aby boli medzi
> hodnotami medzery

A jeste doplnim, ze na to lze pouzit i funkci CONCATENATE.

=CONCATENATE(A1;B1;C1)
=CONCATENATE(A1;" ";B1;" ";C1)


-pp21-
Received on Thu, 5 May 2005 10:43:52 +0200

This archive was generated by hypermail 2.1.8 : 05. 05. 2005, 10:46 CEST