Formula to split out cell

[thelad]

Hi,

Is there formula to split out contents of cell

Basically say in a1 the value is 99999991 ..basically the formula needs to select first 7 figures from left then input a "-" and then have the remaining characters. So in B1 it would be 9999999-1

Other results would be 999999912 would be 9999999-12

any help appreciated

[TABLE="width: 109"]
<colgroup><col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <tbody>[TR]
[TD="width: 70, bgcolor: transparent"][/TD]
[TD="width: 75, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Jon von der Heyden]

Try:

=REPLACE(A1,8,0,"-")

 

[kachaloo]

Replace is perfect.

another messy way

=LEFT(A1,7)&"-"&MID(A1,8,LEN(A1)-7)