用公式把多个连续序列号分到每个单元格

icallyour21333

请教大神，
如何使用公式，把下述有规则的序列号分别放到单个单元格。
总体上是有规则的，有个别是记入错误。不用管。

非常感谢。

20182332; I120180751; I20181681; I20181259; I20180795;I20180152; i20180921; I20181869; I20182041; I20180033;I20180958; I20180209; i20180695; i20182037; i20180671;I20180070; I20350174; I20180243; I20180602; I20180029;I20181561; I20182324; I20350625;I20181893;I20181910; I120180571; I20351247; i20181433; i20181684; I2018143; I20180729; i20181676; i120180057;I20351257;I120181809; I20351137; I20351123; I20181081; I20350980; I20180895; I20181243; I20350961; I20181368; I20351163; I20180980; I20181067; I120180234; I20180391; i20350470; I20180631; I20180153; i20182461; I20350615; I20180360; I20182451; I20180121; I20433983; I20350430; i20182448; I20434097; 120180309;

祝洪忠-

选中数据所在列，【 数据】选项卡，【分列】，按分隔符。

试试