提取汉字

袁国今

在单元格中把名字提出来
{"00:00":[],"23:00":[],"02:00":[],"03:30":[],"06:00":[],"04:00":[],"21:00":[],"08:00":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"01:30":[],"20:30":[],"07:30":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波"],"22:30":[],"05:30":[],"10:30":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"09:30":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"13:00":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"11:00":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"17:00":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"16:30":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"18:30":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波"],"12:30":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"15:00":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"19:00":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波"],"14:30":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"01:00":[],"19:30":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋"],"22:00":[],"05:00":[],"02:30":[],"03:00":[],"20:00":[],"06:30":[],"00:30":[],"07:00":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋"],"09:00":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"23:30":[],"21:30":[],"04:30":[],"08:30":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"10:00":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"12:00":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"15:30":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"14:00":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"17:30":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"11:30":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"16:00":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"13:30":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波","李铭良"],"18:00":["邓轩坚","朱光磊","陈爱国","何正强","罗统辉","杨俊","陈家宝","吴盛健","刘明勋","曾波"]}

苏小亓

怎么提取？取成啥样子

袁国今

苏小亓 发表于 2018-11-19 15:01
怎么提取？取成啥样子

就把名字提取出来就好 名字之间用逗号隔开，谢谢

苏小亓

袁国今 发表于 2018-11-19 15:03
就把名字提取出来就好 名字之间用逗号隔开，谢谢

说了跟没说一样。 广州 1119 排班(1) - 副本.zip (8.84 KB, 下载次数: 8)

2018-11-19 15:08 上传

点击文件名下载附件

袁国今

苏小亓 发表于 2018-11-19 15:08
说了跟没说一样。

对 是的 ，请问您是怎么做的？是用公式吗？

江苏永能朱兴华

=IFERROR(SUBSTITUTE(MID(B1,FIND("[""",B1)+2,FIND("""]",B1)-FIND("[""",B1)-2),"""",""),"")