Hello,
I am aware of the the text to columns feature, but in a super ideal world, I'd rather split my entry into rows.
Without exception, the data I'm looking to split is with the ";" sign. For instance....
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
This entry is always in cell E1, and there could be upto 400 numbers that need separating.
In this instance, I'd like 3009902682 in A1, 20241721 in A2, 3009902689 etc etc etc.
Is this somehow possible by formula and/or VBA?
Many Thanks
I am aware of the the text to columns feature, but in a super ideal world, I'd rather split my entry into rows.
Without exception, the data I'm looking to split is with the ";" sign. For instance....
;3009902682;20241721;3009902689;20177969;3009902686;20213043;20111594;3009902732;20154951;20169509;20015068;3009902692;20081331;20022861;3009902680;3009902697;20147580;3009902707;3009902725;3009902681;3009902696;20167826;20194011;20040230;20122749;20030071;20170639;3009902690;20062649;3009902688;20148229;20039783;20237919;3009902719;20266785;3009902706;3009902698;20071845;3009902687;20070422;3009902684;3009902693;20054425 |
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
This entry is always in cell E1, and there could be upto 400 numbers that need separating.
In this instance, I'd like 3009902682 in A1, 20241721 in A2, 3009902689 etc etc etc.
Is this somehow possible by formula and/or VBA?
Many Thanks