how do I UN-concatenate cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Un-Concatenate 3
Split concatenation 4
Excel Concatenate with line breaks but ignore blank cells 3
,000 Separator after Concatenate 2
Excel Macro to un-mute Audio/speakers. 15
Color within Concatenate 2
Change font formatting in a concatenated string 1
Concatenate Displays Too Many Decimals 2

Back
Top