<div dir="ltr">seems it does not simply split but also adds the delimiter to the result<div><br></div><div><span style="color:rgb(0,0,0);font-family:arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">102:47:00.000</span><br></div><div><span style="color:rgb(0,0,0);font-family:arial,sans,sans-serif;font-size:13px;white-space:pre-wrap"><br></span></div><div><span style="color:rgb(0,0,0);font-family:arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">my initial thought is simple rude: WTF.... cant you just do as told.... )(/&%¤#¤</span></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-09-06 11:54 GMT+02:00 Bo Herrmannsen <span dir="ltr"><<a href="mailto:bo.herrmannsen@gmail.com" target="_blank">bo.herrmannsen@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">So i got the serial output in to a spreadsheet...<div><br></div><div>want to split it up right so its more usefull</div><div><br></div><div>raw data: <span style="color:rgb(0,0,0);font-family:arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">Energy: 102.47 </span></div><div><font color="#000000" face="arial, sans, sans-serif"><span style="white-space:pre-wrap"><br></span></font></div><div><font color="#000000" face="arial, sans, sans-serif"><span style="white-space:pre-wrap"><br></span></font></div><div><font color="#000000" face="arial, sans, sans-serif"><span style="white-space:pre-wrap">formula: </span></font><span dir="auto" style="color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">=</span><span dir="auto" style="color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">split</span><span dir="auto" style="font-weight:bold;color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap;background-color:rgb(229,229,229)">(</span><span dir="auto" style="font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap;color:rgb(247,152,29)">A1</span><span dir="auto" style="color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">;</span><span dir="auto" style="color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap"> </span><span dir="auto" style="color:green;font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">":"</span><span dir="auto" style="color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">;</span><span dir="auto" style="color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap"> </span><span dir="auto" style="color:rgb(17,85,204);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">False</span><span dir="auto" style="font-weight:bold;color:rgb(0,0,0);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap;background-color:rgb(229,229,229)">)</span></div><div><font color="#000000"><span style="white-space:pre-wrap"><font face="Inconsolata, monospace, arial, sans, sans-serif"><b><br></b></font></span></font></div><div><font color="#000000"><span style="white-space:pre-wrap"><font face="Inconsolata, monospace, arial, sans, sans-serif"><b>result: </b></font></span></font><span style="color:rgb(119,119,119);font-family:arial,sans,sans-serif;font-size:100%;text-align:right">102.47.00</span></div><div><font color="#000000"><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif"><br></font></span></span></font></div><div><font color="#000000"><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif">have tried to set the format of the result cell to automatic, text, numbers....</font></span></span></font></div><div><font color="#000000"><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif"><br></font></span></span></font></div><div><font color="#000000"><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif">no matter what it added .00 </font></span></span></font></div><div><font color="#000000"><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif"><br></font></span></span></font></div><div><font color="#000000"><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif">what am i doing wrong?<br clear="all"></font></span></span></font><div><br></div>-- <br><div dir="ltr"><pre><pre><span style="white-space:pre-wrap"> |||||
@(~Ô^Ô~)@
-------------oOo---U---oOo-------------
| |
| Bo Herrmannsen |
| |
| |
| "blessed are the "cracked", |
| for its they who let in the light" |
| Ooo |
|_________________ooO____( )________|
( ) ) /
\ ( (_/
\_)
</span></pre></pre><pre style="white-space:pre-wrap"><br></pre></div>
</div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><pre><pre><span style="white-space:pre-wrap"> |||||
@(~Ô^Ô~)@
-------------oOo---U---oOo-------------
| |
| Bo Herrmannsen |
| |
| |
| "blessed are the "cracked", |
| for its they who let in the light" |
| Ooo |
|_________________ooO____( )________|
( ) ) /
\ ( (_/
\_)
</span></pre></pre><pre style="white-space:pre-wrap"><br></pre></div>
</div>