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
|