Split Numbers in a single cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim - 29 Apr 2008 19:24 GMT

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

Reply to this Message

Zack Barresse - 29 Apr 2008 19:31 GMT

Hi there Tim,

Why not just use Text to Columns using Fixed Width?

HTH

Signature

Zack Barresse

>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
[quoted text clipped - 4 lines]
> Thank you
> Tim

Reply to this Message

Tim - 29 Apr 2008 19:42 GMT

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

Thanks.

> Hi there Tim,
>
[quoted text clipped - 10 lines]
> > Thank you
> > Tim

Reply to this Message

Gord Dibben - 29 Apr 2008 21:44 GMT

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

Gord Dibben MS Excel MVP

>I don't know. That is pretty simple. That will work perfect.
>
[quoted text clipped - 14 lines]
>> > Thank you
>> > Tim

Reply to this Message

Zack Barresse - 29 Apr 2008 21:46 GMT

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.

Signature

Zack Barresse

> Just make sure you designate the columns as text or you will lose the
> leading
[quoted text clipped - 22 lines]
>>> > Thank you
>>> > Tim

Reply to this Message