工号和姓名分开

一杯绿茶来了 · 发表于 2023-10-18 14:45

=LET(s,TEXTSPLIT(SUBSTITUTE(A2,"[","]"),"]",",",1),a,TAKE(s,,1),b,TAKE(s,,-1),HSTACK(TEXTJOIN(",",,a),TEXTJOIN(",",,b)))

sucx007 · 发表于 2023-10-18 14:48

本帖最后由 sucx007 于 2023-10-18 15:03 编辑

=MAP({-1,1},LAMBDA(x,TEXTJOIN(",",,DROP(TEXTSPLIT(A2,"[",{",","]"},1),,x))))

复制代码

=TEXTJOIN(",",,INDEX(TEXTSPLIT($A2,"[",{",","]"},1),,COLUMN(A1)))

复制代码

mtclzw · 发表于 2023-10-18 14:57

本帖最后由 mtclzw 于 2023-10-18 15:01 编辑

OFFICE 365
B2=TEXTJOIN(",",TRUE,TEXTBEFORE(TEXTSPLIT(A2,","),"["))
C2=TEXTJOIN(",",TRUE,TEXTAFTER(TEXTBEFORE(TEXTSPLIT(A2,","),"]"),"["))

nie414006 · 发表于 2023-10-18 15:53

nie414006 · 发表于 2023-10-18 15:54

伊可赛二 · 发表于 2023-10-19 07:38

烟笼寒水客 · 发表于 2023-10-19 08:27

24,25,26，三层楼的公式，让人看的云里雾里的。

boy8199 · 发表于 2023-10-19 11:52

方方法5 发表于 2023-10-18 10:34
直接替换不就好了嘛干嘛非得用函数呢
替换空
]*[ 替换，

干得漂亮!有些人为了公式而公式

ggw092 · 发表于 2023-12-27 14:50

WPS:

妍琪爸爸 · 发表于 2024-2-28 14:05

mtclzw 发表于 2023-10-18 14:57
OFFICE 365
B2=TEXTJOIN(",",TRUE,TEXTBEFORE(TEXTSPLIT(A2,","),"["))
C2=TEXTJOIN(",",TRUE,TEXTAFTER( ...

成功的,向大佬学习。

		自动登录	找回密码
密码			免费注册

[已解决] 工号和姓名分开