GHCND:USC00047741,SAN DIEGO SEAWORLD CA US,20100129,178,89
how do I just get the place, date and one tenth of the temperature numbers 178,89
there are hundreds of these things to do!
thanks all
GHCND:USC00047741,SAN DIEGO SEAWORLD CA US,20100129,178,89
how do I just get the place, date and one tenth of the temperature numbers 178,89
there are hundreds of these things to do!
thanks all
can you show the desired output?
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
20100129,178,89
29 jan 2010 in one column
17.8 in another
And 8.9 in the last
Thanks
In B1
=TEXT(TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",255)),255*2,255)),"0000\/00\/00")+0
and format cell as Custom: d-mmm-yyyy
In C1
=TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",255)),255*3,255))/10
in D1
=TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",255)),255*4,255))/10
Row\Col A B C D 1GHCND:USC00047741,SAN DIEGO SEAWORLD CA US,20100129,178,89 29-Jan-2010 17.8 8.9
Last edited by AlKey; 02-23-2015 at 04:55 PM.
wow that look complicated!
thanks
You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks