how do I UN-concatenate cells

J

julia

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

Dave O

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
 
G

Graham Haughs

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

Regards
Graham
 
Top