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

<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> </tbody>

 

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