Hello,
i need do extract digits from One cell into 5 separate.
<colgroup><col style="mso-width-source:userset;mso-width-alt:2706;width:56pt" width="74"> <col style="width:48pt" width="64" span="4"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> </colgroup><tbody>
</tbody>
Thank you for a help with a formula, and/or Macro.
i need do extract digits from One cell into 5 separate.
A | B | C | D | E | F |
2digits | 3digits | 1digit | 3digits | 4digits | 13digits string |
01 | 259 | 6 | 310 | 7510 | 0125963107510 |
Note: "Zero" can be in any part of new strings. Not to lose it. |
<colgroup><col style="mso-width-source:userset;mso-width-alt:2706;width:56pt" width="74"> <col style="width:48pt" width="64" span="4"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> </colgroup><tbody>
</tbody>
Thank you for a help with a formula, and/or Macro.