I am working with Quattro spreadsheets, which appear to be identical to excel.  my work has me pasting the latitude, longitude into two cells,  they originate, however, as one string, missing the decimal points.  It seems stupid to be pasting and modifying the string, hundreds of times in a row. I'd like to paste the pair into an empty cell and then define the destination cells as the portion of the lat/long string.  can you help me? 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"
they are always the same decimal precision, same length.  I don't see a substr function when I look thru the help for Quattro.  I'm getting tired of all the tabbing and deleting, not to mention it is very error prone.
   I will be correcting NAVTEQ maps for Jacksonville this week, the US's largest city! (area-wise!)  Last time I spent any time there I was bringing the brewery on-line! (1982?)  Reply off-list, of course.

Kevin Lane  Portland, OR
e-mail-> n3773@comcast.net