software

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

JMWhat'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)quot;JMquot; gt; wrote in message
...
gt; Hello, Is it possible to insert a period into the middle of a string of
gt; numbers? I have 800 numbers I need to change in A1 to A801. Can I do this
gt; without having to retype the entire column?
gt;
gt; Here's an example:
gt; I need to change 26150G to 26.150G
gt;
gt; Any help will be greatly appreciated.
gt; Thank You
gt;
gt; JM
gt;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

JMquot;Peo Sjoblomquot; wrote:

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

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

--

Dave Peterson

Than you very much! It worked perfectly!

I appreciate your all you help.

JM

quot;Dave Petersonquot; wrote:

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

Another way

=SUBSTITUTE(A1,LEFT(A1,2),LEFT(A1,2)amp;quot;.quot;)

--
Regards,

Peo Sjoblom

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

--

Dave Peterson

Doh!

--
Regards,

Peo Sjoblom

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

=SUBSTITUTE(A3,LEFT(A3,2),LEFT(A3,2)amp;quot;.quot;,1)

--
Regards,

Peo Sjoblom

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

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

--

Dave Peterson