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>
[TD="class: xl69, width: 449, colspan: 6"][/TD]
[TD="class: xl72"]A[/TD]
[TD="class: xl73"]B[/TD]
[TD="class: xl73"]C[/TD]
[TD="class: xl73"]D[/TD]
[TD="class: xl73"]E [/TD]
[TD="class: xl74"]F[/TD]
[TD="class: xl75"]2digits[/TD]
[TD="class: xl66"]3digits[/TD]
[TD="class: xl66"]1digit[/TD]
[TD="class: xl66"]3digits[/TD]
[TD="class: xl66"]4digits[/TD]
[TD="class: xl76"]13digits string[/TD]
[TD="class: xl77"]01[/TD]
[TD="class: xl68"]259[/TD]
[TD="class: xl68"]6[/TD]
[TD="class: xl68"]310[/TD]
[TD="class: xl68"]7510[/TD]
[TD="class: xl78"]0125963107510[/TD]
[TD="class: xl79"] [/TD]
[TD="class: xl80"] [/TD]
[TD="class: xl81, colspan: 6"]Note: "Zero" can be in any part of new strings. Not to lose it.[/TD]
</tbody>
Thank you for a help with a formula, and/or Macro.
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>
[TD="class: xl69, width: 449, colspan: 6"][/TD]
[TD="class: xl72"]A[/TD]
[TD="class: xl73"]B[/TD]
[TD="class: xl73"]C[/TD]
[TD="class: xl73"]D[/TD]
[TD="class: xl73"]E [/TD]
[TD="class: xl74"]F[/TD]
[TD="class: xl75"]2digits[/TD]
[TD="class: xl66"]3digits[/TD]
[TD="class: xl66"]1digit[/TD]
[TD="class: xl66"]3digits[/TD]
[TD="class: xl66"]4digits[/TD]
[TD="class: xl76"]13digits string[/TD]
[TD="class: xl77"]01[/TD]
[TD="class: xl68"]259[/TD]
[TD="class: xl68"]6[/TD]
[TD="class: xl68"]310[/TD]
[TD="class: xl68"]7510[/TD]
[TD="class: xl78"]0125963107510[/TD]
[TD="class: xl79"] [/TD]
[TD="class: xl80"] [/TD]
[TD="class: xl81, colspan: 6"]Note: "Zero" can be in any part of new strings. Not to lose it.[/TD]
</tbody>
Thank you for a help with a formula, and/or Macro.