Split Numbers in a single cell

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have a string of numbers in a cell and I want to split them into seperate
cells based on position. For example I need 080417007401181080 to be split
into 3 cells as follows, 080417/00740/1181080. Is there a macro I can run
that will automate this?

Thank you
Tim
 
Just make sure you designate the columns as text or you will lose the leading
zeros.


Gord Dibben MS Excel MVP
 
Hmm, kind of a toss up for me. If the numbers are required to be numbers
(depending on massaging the data) I would just reformat the columns
afterwards with a 000000/00000/0000000 format. Of course, if the OP wants
their numbers as text.. :)

Take care Gord.
 
Back
Top