Adding decimal to a number/text string

[stylencia18]

Good morning:

How do I convert S43422A to S43.422A. I cant figure out how to add decimal.

Thank you!!

 

[Scott T]

If the decimal will always be in the same place and the string the same length

=LEFT(A1,3)&"."&RIGHT(A1,4)

 

[stylencia18]

Thank you!

 

[jtakw]

Hi,

Also try:

Book1
	I	J
1	S43422A	S43.422A
Sheet487

Cell Formulas
Range	Formula
J1	=REPLACE(I1,4,0,".")