View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

Is the string of numbers always 5 numbers, a dot, 5 numbers, a dot,
etc? If it's *always* in that format you can use a MID() function. If
the separate components are between dots but irregularly spaced it
becomes trickier.

If it's the easy scenario, and supposing your string is in cell A1, try
=MID(A1,1,5)
=MID(A1,7,5)
=MID(A1,13,5)
etc