如何在excel 里提取文字?

如何在excel 里提取文字?

方法一

=TEXTJOIN(",",1,DROP(TAKE(TEXTSPLIT(A1,",","。",1),1),,1))

方法二

=TEXTAFTER(TEXTBEFORE(A1,"。",1),",",1)