Re: dotaz EXCEL 2000

From: pp21 (pp21@mail.cz)
Date: 21. 07. 2001, 15:57 CEST

Previous message: Pavel Trubl: "Re: prosba"
In reply to: Jan Julínek: "dotaz EXCEL 2000"
Next in thread: Kobylková Simona: "RE: dotaz EXCEL 2000"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

> v excelu ....
> 4300. 010401 194.228.166.22
> lze nejak dosahnout toho, aby se napr do sloupce F automaticky
> zkopirovala jen cast textu. V mem pripade je to ta IP adresa
> " 194.228.166.22 ". Pres makra by to slo ???

Pres makro mi to pripadne zbytecny, tipuju, ze to potrebujes udelat jen
jednou, jednorazove, na to by ti mohlo stacit data -> text do sloupcu... ->
oddelovac mezera. Tim se to to rozdeli do sloupcu vzdy tam, kde mas mezeru.

Pokud by ta IP adresa mela vzdy stejny pocet znaku (coz bohuzel nema), slo
by to jeste kombinaci funkci DELKA() a ZPRAVA().

Staci takhle?

-pp21-

Previous message: Pavel Trubl: "Re: prosba"
In reply to: Jan Julínek: "dotaz EXCEL 2000"
Next in thread: Kobylková Simona: "RE: dotaz EXCEL 2000"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.2 : 04. 09. 2001, 09:04 CEST