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

Hi there Tim,

Why not just use Text to Columns using Fixed Width?

HTH

--
Zack Barresse



"Tim" <Tim@discussions.microsoft.com> wrote in message
news:B8F38490-0D16-4130-AC51-D63D78D8F03C@microsoft.com...
>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

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

Thanks.

"Zack Barresse" wrote:

> Hi there Tim,
>
> Why not just use Text to Columns using Fixed Width?
>
> HTH
>
> --
> Zack Barresse
>
>
>
> "Tim" <Tim@discussions.microsoft.com> wrote in message
> news:B8F38490-0D16-4130-AC51-D63D78D8F03C@microsoft.com...
> >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

On Tue, 29 Apr 2008 11:42:04 -0700, Tim <Tim@discussions.microsoft.com> wrote:

>I don't know. That is pretty simple. That will work perfect.
>
>Thanks.
>
>"Zack Barresse" wrote:
>
>> Hi there Tim,
>>
>> Why not just use Text to Columns using Fixed Width?
>>
>> HTH
>>
>> --
>> Zack Barresse
>>
>>
>>
>> "Tim" <Tim@discussions.microsoft.com> wrote in message
>> news:B8F38490-0D16-4130-AC51-D63D78D8F03C@microsoft.com...
>> >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
>>

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.

--
Zack Barresse



"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:e32f14ti18oail4k83nh8g27aou1dhbmke@4ax.com...
> Just make sure you designate the columns as text or you will lose the
> leading
> zeros.
>
>
> Gord Dibben MS Excel MVP
>
> On Tue, 29 Apr 2008 11:42:04 -0700, Tim <Tim@discussions.microsoft.com>
> wrote:
>
>>I don't know. That is pretty simple. That will work perfect.
>>
>>Thanks.
>>
>>"Zack Barresse" wrote:
>>
>>> Hi there Tim,
>>>
>>> Why not just use Text to Columns using Fixed Width?
>>>
>>> HTH
>>>
>>> --
>>> Zack Barresse
>>>
>>>
>>>
>>> "Tim" <Tim@discussions.microsoft.com> wrote in message
>>> news:B8F38490-0D16-4130-AC51-D63D78D8F03C@microsoft.com...
>>> >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
>>>
>