How can I insert a period into exsisting cells?

[JM]

Hello, Is it possible to insert a period into the middle of a string of
numbers? I have 800 numbers I need to change in A1 to A801. Can I do this
without having to retype the entire column?

Here's an example:
I need to change 26150G to 26.150G

Any help will be greatly appreciated.
Thank You

JM

[Peo Sjoblom]

What's the rule where to insert it, will it always be inserted after the 2
character like in 23.150G or what would the rule be?

--
Regards,

Peo Sjoblom

(No private emails please)


"JM" <[email protected]> wrote in message
news:[email protected]...
> Hello, Is it possible to insert a period into the middle of a string of
> numbers? I have 800 numbers I need to change in A1 to A801. Can I do this
> without having to retype the entire column?
>
> Here's an example:
> I need to change 26150G to 26.150G
>
> Any help will be greatly appreciated.
> Thank You
>
> JM
>

[JM]

Sorry I should have made it clear. Yes the it will be always be inserted
after the first 2 digits. I need to insert the period after the first 2
digtis.

26150G to 26.150G
33207G to 33.207G
03273G to 03.273G
05069G to 05.069G and so on.

Thanks

JM


"Peo Sjoblom" wrote:

> What's the rule where to insert it, will it always be inserted after the 2
> character like in 23.150G or what would the rule be?
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
>
> "JM" <[email protected]> wrote in message
> news:[email protected]...
> > Hello, Is it possible to insert a period into the middle of a string of
> > numbers? I have 800 numbers I need to change in A1 to A801. Can I do this
> > without having to retype the entire column?
> >
> > Here's an example:
> > I need to change 26150G to 26.150G
> >
> > Any help will be greatly appreciated.
> > Thank You
> >
> > JM
> >
>
>

[Dave Peterson]

=left(a1,2)&"."&mid(a1,3,255)



JM wrote:
>
> Sorry I should have made it clear. Yes the it will be always be inserted
> after the first 2 digits. I need to insert the period after the first 2
> digtis.
>
> 26150G to 26.150G
> 33207G to 33.207G
> 03273G to 03.273G
> 05069G to 05.069G and so on.
>
> Thanks
>
> JM
>
> "Peo Sjoblom" wrote:
>
> > What's the rule where to insert it, will it always be inserted after the 2
> > character like in 23.150G or what would the rule be?
> >
> > --
> > Regards,
> >
> > Peo Sjoblom
> >
> > (No private emails please)
> >
> >
> > "JM" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hello, Is it possible to insert a period into the middle of a string of
> > > numbers? I have 800 numbers I need to change in A1 to A801. Can I do this
> > > without having to retype the entire column?
> > >
> > > Here's an example:
> > > I need to change 26150G to 26.150G
> > >
> > > Any help will be greatly appreciated.
> > > Thank You
> > >
> > > JM
> > >
> >
> >

--

Dave Peterson

[JM]

Than you very much! It worked perfectly!

I appreciate your all you help.

JM

"Dave Peterson" wrote:

> =left(a1,2)&"."&mid(a1,3,255)
>
>
>
> JM wrote:
> >
> > Sorry I should have made it clear. Yes the it will be always be inserted
> > after the first 2 digits. I need to insert the period after the first 2
> > digtis.
> >
> > 26150G to 26.150G
> > 33207G to 33.207G
> > 03273G to 03.273G
> > 05069G to 05.069G and so on.
> >
> > Thanks
> >
> > JM
> >
> > "Peo Sjoblom" wrote:
> >
> > > What's the rule where to insert it, will it always be inserted after the 2
> > > character like in 23.150G or what would the rule be?
> > >
> > > --
> > > Regards,
> > >
> > > Peo Sjoblom
> > >
> > > (No private emails please)
> > >
> > >
> > > "JM" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > Hello, Is it possible to insert a period into the middle of a string of
> > > > numbers? I have 800 numbers I need to change in A1 to A801. Can I do this
> > > > without having to retype the entire column?
> > > >
> > > > Here's an example:
> > > > I need to change 26150G to 26.150G
> > > >
> > > > Any help will be greatly appreciated.
> > > > Thank You
> > > >
> > > > JM
> > > >
> > >
> > >
>
> --
>
> Dave Peterson
>

[Peo Sjoblom]

Another way

=SUBSTITUTE(A1,LEFT(A1,2),LEFT(A1,2)&".")

--
Regards,

Peo Sjoblom

(No private emails please)


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> =left(a1,2)&"."&mid(a1,3,255)
>
>
>
> JM wrote:
>>
>> Sorry I should have made it clear. Yes the it will be always be inserted
>> after the first 2 digits. I need to insert the period after the first 2
>> digtis.
>>
>> 26150G to 26.150G
>> 33207G to 33.207G
>> 03273G to 03.273G
>> 05069G to 05.069G and so on.
>>
>> Thanks
>>
>> JM
>>
>> "Peo Sjoblom" wrote:
>>
>> > What's the rule where to insert it, will it always be inserted after
>> > the 2
>> > character like in 23.150G or what would the rule be?
>> >
>> > --
>> > Regards,
>> >
>> > Peo Sjoblom
>> >
>> > (No private emails please)
>> >
>> >
>> > "JM" <[email protected]> wrote in message
>> > news:[email protected]...
>> > > Hello, Is it possible to insert a period into the middle of a string
>> > > of
>> > > numbers? I have 800 numbers I need to change in A1 to A801. Can I do
>> > > this
>> > > without having to retype the entire column?
>> > >
>> > > Here's an example:
>> > > I need to change 26150G to 26.150G
>> > >
>> > > Any help will be greatly appreciated.
>> > > Thank You
>> > >
>> > > JM
>> > >
>> >
>> >
>
> --
>
> Dave Peterson

[Dave Peterson]

But watch out for things like:
26260G



Peo Sjoblom wrote:
>
> Another way
>
> =SUBSTITUTE(A1,LEFT(A1,2),LEFT(A1,2)&".")
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > =left(a1,2)&"."&mid(a1,3,255)
> >
> >
> >
> > JM wrote:
> >>
> >> Sorry I should have made it clear. Yes the it will be always be inserted
> >> after the first 2 digits. I need to insert the period after the first 2
> >> digtis.
> >>
> >> 26150G to 26.150G
> >> 33207G to 33.207G
> >> 03273G to 03.273G
> >> 05069G to 05.069G and so on.
> >>
> >> Thanks
> >>
> >> JM
> >>
> >> "Peo Sjoblom" wrote:
> >>
> >> > What's the rule where to insert it, will it always be inserted after
> >> > the 2
> >> > character like in 23.150G or what would the rule be?
> >> >
> >> > --
> >> > Regards,
> >> >
> >> > Peo Sjoblom
> >> >
> >> > (No private emails please)
> >> >
> >> >
> >> > "JM" <[email protected]> wrote in message
> >> > news:[email protected]...
> >> > > Hello, Is it possible to insert a period into the middle of a string
> >> > > of
> >> > > numbers? I have 800 numbers I need to change in A1 to A801. Can I do
> >> > > this
> >> > > without having to retype the entire column?
> >> > >
> >> > > Here's an example:
> >> > > I need to change 26150G to 26.150G
> >> > >
> >> > > Any help will be greatly appreciated.
> >> > > Thank You
> >> > >
> >> > > JM
> >> > >
> >> >
> >> >
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

[Peo Sjoblom]

Doh!

--
Regards,

Peo Sjoblom

(No private emails please)


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> But watch out for things like:
> 26260G
>
>
>
> Peo Sjoblom wrote:
>>
>> Another way
>>
>> =SUBSTITUTE(A1,LEFT(A1,2),LEFT(A1,2)&".")
>>
>> --
>> Regards,
>>
>> Peo Sjoblom
>>
>> (No private emails please)
>>
>> "Dave Peterson" <[email protected]> wrote in message
>> news:[email protected]...
>> > =left(a1,2)&"."&mid(a1,3,255)
>> >
>> >
>> >
>> > JM wrote:
>> >>
>> >> Sorry I should have made it clear. Yes the it will be always be
>> >> inserted
>> >> after the first 2 digits. I need to insert the period after the first
>> >> 2
>> >> digtis.
>> >>
>> >> 26150G to 26.150G
>> >> 33207G to 33.207G
>> >> 03273G to 03.273G
>> >> 05069G to 05.069G and so on.
>> >>
>> >> Thanks
>> >>
>> >> JM
>> >>
>> >> "Peo Sjoblom" wrote:
>> >>
>> >> > What's the rule where to insert it, will it always be inserted after
>> >> > the 2
>> >> > character like in 23.150G or what would the rule be?
>> >> >
>> >> > --
>> >> > Regards,
>> >> >
>> >> > Peo Sjoblom
>> >> >
>> >> > (No private emails please)
>> >> >
>> >> >
>> >> > "JM" <[email protected]> wrote in message
>> >> > news:[email protected]...
>> >> > > Hello, Is it possible to insert a period into the middle of a
>> >> > > string
>> >> > > of
>> >> > > numbers? I have 800 numbers I need to change in A1 to A801. Can I
>> >> > > do
>> >> > > this
>> >> > > without having to retype the entire column?
>> >> > >
>> >> > > Here's an example:
>> >> > > I need to change 26150G to 26.150G
>> >> > >
>> >> > > Any help will be greatly appreciated.
>> >> > > Thank You
>> >> > >
>> >> > > JM
>> >> > >
>> >> >
>> >> >
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson

[Peo Sjoblom]

Oops Forgot the formula

=SUBSTITUTE(A3,LEFT(A3,2),LEFT(A3,2)&".",1)

--
Regards,

Peo Sjoblom

(No private emails please)


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> But watch out for things like:
> 26260G
>
>
>
> Peo Sjoblom wrote:
>>
>> Another way
>>
>> =SUBSTITUTE(A1,LEFT(A1,2),LEFT(A1,2)&".")
>>
>> --
>> Regards,
>>
>> Peo Sjoblom
>>
>> (No private emails please)
>>
>> "Dave Peterson" <[email protected]> wrote in message
>> news:[email protected]...
>> > =left(a1,2)&"."&mid(a1,3,255)
>> >
>> >
>> >
>> > JM wrote:
>> >>
>> >> Sorry I should have made it clear. Yes the it will be always be
>> >> inserted
>> >> after the first 2 digits. I need to insert the period after the first
>> >> 2
>> >> digtis.
>> >>
>> >> 26150G to 26.150G
>> >> 33207G to 33.207G
>> >> 03273G to 03.273G
>> >> 05069G to 05.069G and so on.
>> >>
>> >> Thanks
>> >>
>> >> JM
>> >>
>> >> "Peo Sjoblom" wrote:
>> >>
>> >> > What's the rule where to insert it, will it always be inserted after
>> >> > the 2
>> >> > character like in 23.150G or what would the rule be?
>> >> >
>> >> > --
>> >> > Regards,
>> >> >
>> >> > Peo Sjoblom
>> >> >
>> >> > (No private emails please)
>> >> >
>> >> >
>> >> > "JM" <[email protected]> wrote in message
>> >> > news:[email protected]...
>> >> > > Hello, Is it possible to insert a period into the middle of a
>> >> > > string
>> >> > > of
>> >> > > numbers? I have 800 numbers I need to change in A1 to A801. Can I
>> >> > > do
>> >> > > this
>> >> > > without having to retype the entire column?
>> >> > >
>> >> > > Here's an example:
>> >> > > I need to change 26150G to 26.150G
>> >> > >
>> >> > > Any help will be greatly appreciated.
>> >> > > Thank You
>> >> > >
>> >> > > JM
>> >> > >
>> >> >
>> >> >
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson

[Dave Peterson]

Ok!

Peo Sjoblom wrote:
>
> Oops Forgot the formula
>
> =SUBSTITUTE(A3,LEFT(A3,2),LEFT(A3,2)&".",1)
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > But watch out for things like:
> > 26260G
> >
> >
> >
> > Peo Sjoblom wrote:
> >>
> >> Another way
> >>
> >> =SUBSTITUTE(A1,LEFT(A1,2),LEFT(A1,2)&".")
> >>
> >> --
> >> Regards,
> >>
> >> Peo Sjoblom
> >>
> >> (No private emails please)
> >>
> >> "Dave Peterson" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > =left(a1,2)&"."&mid(a1,3,255)
> >> >
> >> >
> >> >
> >> > JM wrote:
> >> >>
> >> >> Sorry I should have made it clear. Yes the it will be always be
> >> >> inserted
> >> >> after the first 2 digits. I need to insert the period after the first
> >> >> 2
> >> >> digtis.
> >> >>
> >> >> 26150G to 26.150G
> >> >> 33207G to 33.207G
> >> >> 03273G to 03.273G
> >> >> 05069G to 05.069G and so on.
> >> >>
> >> >> Thanks
> >> >>
> >> >> JM
> >> >>
> >> >> "Peo Sjoblom" wrote:
> >> >>
> >> >> > What's the rule where to insert it, will it always be inserted after
> >> >> > the 2
> >> >> > character like in 23.150G or what would the rule be?
> >> >> >
> >> >> > --
> >> >> > Regards,
> >> >> >
> >> >> > Peo Sjoblom
> >> >> >
> >> >> > (No private emails please)
> >> >> >
> >> >> >
> >> >> > "JM" <[email protected]> wrote in message
> >> >> > news:[email protected]...
> >> >> > > Hello, Is it possible to insert a period into the middle of a
> >> >> > > string
> >> >> > > of
> >> >> > > numbers? I have 800 numbers I need to change in A1 to A801. Can I
> >> >> > > do
> >> >> > > this
> >> >> > > without having to retype the entire column?
> >> >> > >
> >> >> > > Here's an example:
> >> >> > > I need to change 26150G to 26.150G
> >> >> > >
> >> >> > > Any help will be greatly appreciated.
> >> >> > > Thank You
> >> >> > >
> >> >> > > JM
> >> >> > >
> >> >> >
> >> >> >
> >> >
> >> > --
> >> >
> >> > Dave Peterson
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

[chooter69]

How do I put multiple periods in a cell. For example, my cell contains GX23NE00COM0000. I want it to be GX.23.NE00.COM00.00. Thanks for your help.

[FDibbins]

How do I put multiple periods in a cell. For example, my cell contains GX23NE00COM0000. I want it to be GX.23.NE00.COM00.00. Thanks for your help.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread