How can I insert a period into exsisting cells?

J

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
 
P

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)
 
J

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
 
D

Dave Peterson

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


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
Click to expand...
 
P

Peo Sjoblom

Another way

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
D

Dave Peterson

But watch out for things like:
26260G



Peo said:
Another way

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

--
Regards,

Peo Sjoblom

(No private emails please)
Click to expand...
 
P

Peo Sjoblom

Oops Forgot the formula

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top