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