Split Numbers in a single cell

[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

 

[Zack Barresse]

Hi there Tim,

Why not just use Text to Columns using Fixed Width?

HTH

 

[Tim]

I don't know. That is pretty simple. That will work perfect.

Thanks.

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Zack Barresse]

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.