how do I UN-concatenate cells
 

I have a string of numbers 00633.84010.12740.0000.10101 that I need to break
out into the separate components.

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

Hi Julia,
If you try Data Text to Columns and follow the options, this
may be what you are after.

Regards
Graham

julia wrote:
I have a string of numbers 00633.84010.12740.0000.10101 that I need to break
out into the separate components.