从一堆数据当中导出特定字符后的数据

cexo790527

请教各位大佬，我从手机APP里面导入了房贷信息，里面是一堆连续文本，我想从里面将每个月的还贷金额导出，并排列到相应的格内。请问如何导出。期望格式为附图，具体文本如下：
￥2,074.032018-07-16 21:50还款+￥2,078.692018-06-16 21:44还款+￥2,083.352018-05-17 21:50还款+￥2,088.022018-04-16 21:47还款+￥2,092.682018-03-16 21:49还款+￥2,097.342018-02-16 21:06还款+￥2,102.002018-01-16 21:46还款+￥2,106.662017-12-16 21:41还款+￥2,111.332017-11-16 21:48还款+￥2,115.992017-10-16 21:44还款+￥2,120.652017-09-16 21:36还款+￥2,125.312017-08-16 21:41还款+￥2,129.972017-07-16 21:41还款+￥2,134.632017-06-16 21:39还款+￥2,139.302017-05-16 21:57还款+￥2,143.962017-04-16 21:46还款+￥2,148.622017-03-16 21:50还款+￥2,153.282017-02-16 21:46还款+￥2,157.942017-01-16 21:48还款+￥2,162.612016-12-16 21:41还款+￥2,167.272016-11-16 21:40还款+￥2,171.932016-10-16 21:56还款+￥2,176.592016-09-16 22:03还款+￥2,181.252016-08-16 22:04还款+￥2,185.912016-07-16 21:56还款+￥2,190.582016-06-16 21:59还款+￥2,195.242016-05-16 22:02还款+￥2,199.902016-04-16 21:51还款+￥2,204.562016-03-16 22:09还款+￥2,209.222016-02-16 22:02还款+￥2,350.652016-01-16 22:07还款+￥2,493.262015-12-16 22:10还款+￥2,499.112015-11-16 22:18还款+￥2,504.962015-10-16 21:55还款+￥2,510.812015-09-16 21:59还款+￥2,516.662015-08-16 21:45还款+￥2,522.522015-07-16 21:52还款+￥2,528.372015-06-16 21:56还款+￥2,534.222015-05-16 21:51还款+￥2,540.072015-04-16 21:58还款+￥2,545.922015-03-16 22:00

wp231957

=HSTACK(RIGHT(TOCOL(TEXTBEFORE(TEXTSPLIT(A1,"+")," ")),10),LEFT(TOCOL(TEXTBEFORE(TEXTSPLIT(A1,"+")," ")),9))

wp231957

=HSTACK(SEQUENCE(COUNTA(TEXTSPLIT(A1,"+"))),RIGHT(TOCOL(TEXTBEFORE(TEXTSPLIT(A1,"+")," ")),10),LEFT(TOCOL(TEXTBEFORE(TEXTSPLIT(A1,"+")," ")),9))
前面添加序数

wp231957

公式还可以精简一点点
=LET(a,TEXTSPLIT(A1,"+"),b,TOCOL(TEXTBEFORE(a," ")),HSTACK(SEQUENCE(COUNTA(a)),RIGHT(b,10),LEFT(b,9)))

祝洪忠-

两次分列

cexo790527

感谢两位大佬的细心指教，受益良多，感谢感谢!