|
Kevin asked:
> I figure if I ask the right person that this is a total no-brainer.
>
> example: string that I copy from a map "-7719420, 3871104"
>
> I need to split it into two cells that would read "-77.19420" and
> "38.71104"
If in EXCEL
Col-A/Row-1 = -7719420,3871104
Col-B/Row-2 = =LEFT(A1, SEARCH(",",A1)-1)/100000
Col-C/Row-3 = =RIGHT(A1,LEN(A1)-SEARCH(",",A1))/100000
The result is:
A B C
-7719420,3871104 -77.1942 38.71104
Hope that helps...will consult for flying time ;-)
Joe Hull
Bellevue (Seattle), Washington
Cozy MkIV #991 (working on Engine & Electrical & Finishing)
http://www.maddyhome.com/canardpages/pages/JoeHull/index.html
|
|