Re: Excelio zinovams ( 160kB) [Mudyla @ 2011-09-23 19:13:12]

Tema: Re: Excelio zinovams ( 160kB)
Autorius: Mudyla
Data: 2011-09-23 19:13:12
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=windows-1257 http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7601.17655">
<STYLE></STYLE>
</HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px" 
id=MailContainerBody leftMargin=0 topMargin=0 CanvasTabStop="true" 
name="Compose message area">
<DIV><FONT size=2 face=Arial>Manau paprasciausias budas, t.y. be jokiu formuliu 
ar macros'u butu naudoti "Text to columns" mygtuka. Isskaidysi A stulpeli i 
laika ir data, o po to susidesi i kuriuos nori stulpelius. Manau, jei vienu metu 
naudosi ir kableli, ir tarpa kaip delimeterius, tai normaliai 
atskirs.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<BLOCKQUOTE 
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px" 
dir=ltr>
  <DIV>"erniux" &lt;<A 
  title="mailto:erniux@gmail.com&#10;CTRL + Click to follow link" 
  href="mailto:erniux@gmail.com">erniux@gmail.com</A>&gt; wrote in message <A 
  title="news:j5i94p$g5u$1@trimpas.omnitel.net&#10;CTRL + Click to follow link" 
  href="news:j5i94p$g5u$1@trimpas.omnitel.net">news:j5i94p$g5u$1@trimpas.omnitel.net</A>...</DIV>
  <DIV>
  <TABLE style="WIDTH: 806pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 
  cellPadding=0 width=1074>
    <COLGROUP><FONT face=Arial>
    <COL style="WIDTH: 806pt; mso-width-source: userset; mso-width-alt: 39277" 
    width=1074><FONT size=2></FONT></FONT>
    <TBODY>
    <TR style="HEIGHT: 15pt" height=20>
      <TD 
      style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 806pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" 
      height=20 width=1074>
        <DIV><FONT size=2 face=Arial>Sveiki, energijos matuoklis duoda 
        valandines elektros snaudas csv formate pvz:</FONT></DIV>
        <DIV><FONT size=2 face=Arial>'12:00 
      2011/09/23,0.7524,0,,,</FONT></DIV></TD></TR></TBODY></TABLE></DIV>
  <DIV><FONT size=2 face=Arial>Kaip padaryti, kad celje B bt atrenkamos 
  valandos t.y 12:00, C celje atsirast 2011/09/23 ir D atsirast 
  0.7524</FONT></DIV>
  <DIV><FONT size=2 face=Arial>Ai</FONT></DIV></BLOCKQUOTE></BODY></HTML>