请帮忙解决 “超过255个字符” 或 “此格式 支持的数目”困难

laowa

在excel 的 B列粘贴 下内容 正常
=CONCATENATE("
Dialogue: 0,0:00:00.00,0:00:03.00,Default,,0,0,0,fx,{\an5\moves4(120,895,120,1145,120,945,120,995,0,400)\clip(35,960,205,1080)\3c&H0000FF&\bord4\blur6}",MID(A1,1,1),"
Dialogue: 1,0:00:00.20,0:00:00.62,Default,,0,0,0,fx,{\an5\pos(120,995)\c&HFFFFFFF&\3c&HFFFFFFF&\bord4\blur6\t(0,48,0.5,\fscx150\fscy150\c&HFFFFFF&\3c&HFFFFFF&)\t(48,120,\fscx100\fscy100\c&HFFFFFFF&\3c&H0000FF&)\fad(0,300)}",MID(A1,1,1),"
Dialogue: 1,0:00:00.04,0:00:00.76,Default,,0,0,0,fx,{\an5\pos(172,916)\c&HF5B900&\bord0\blur3\fscx0\fscy0\t(0,637,\fscx99\fscy99\alpha&HFF&)\p1}m 30 0 b 0 0 0 44 30 44 b 60 44 60 0 30 0",MID(A1,1,1),"
Dialogue: 1,0:00:00.24,0:00:00.96,Default,,0,0,0,fx,{\an5\pos(102,927)\c&HE61914&\bord0\blur4\fscx0\fscy0\t(0,835,\fscx91\fscy91\alpha&HFF&)\p1}m 30 0 b 0 0 0 44 30 44 b 60 44 60 0 30 0",MID(A1,1,1))

但是，粘贴内容再增加 如下，则报错
=CONCATENATE("
Dialogue: 0,0:00:00.00,0:00:03.00,Default,,0,0,0,fx,{\an5\moves4(120,895,120,1145,120,945,120,995,0,400)\clip(35,960,205,1080)\3c&H0000FF&\bord4\blur6}",MID(A1,1,1),"
Dialogue: 1,0:00:00.20,0:00:00.62,Default,,0,0,0,fx,{\an5\pos(120,995)\c&HFFFFFFF&\3c&HFFFFFFF&\bord4\blur6\t(0,48,0.5,\fscx150\fscy150\c&HFFFFFF&\3c&HFFFFFF&)\t(48,120,\fscx100\fscy100\c&HFFFFFFF&\3c&H0000FF&)\fad(0,300)}",MID(A1,1,1),"
Dialogue: 1,0:00:00.04,0:00:00.76,Default,,0,0,0,fx,{\an5\pos(172,916)\c&HF5B900&\bord0\blur3\fscx0\fscy0\t(0,637,\fscx99\fscy99\alpha&HFF&)\p1}m 30 0 b 0 0 0 44 30 44 b 60 44 60 0 30 0",MID(A1,1,1),"
Dialogue: 1,0:00:00.24,0:00:00.96,Default,,0,0,0,fx,{\an5\pos(102,927)\c&HE61914&\bord0\blur4\fscx0\fscy0\t(0,835,\fscx91\fscy91\alpha&HFF&)\p1}m 30 0 b 0 0 0 44 30 44 b 60 44 60 0 30 0",MID(A1,1,1),"
Dialogue: 0,0:00:00.00,0:00:03.00,Default,,0,0,0,fx,{\an5\moves4(120,895,120,1145,120,945,120,995,0,400)\clip(35,960,205,1080)\3c&H0000FF&\bord4\blur6}",MID(A1,1,1),"
Dialogue: 1,0:00:00.20,0:00:00.62,Default,,0,0,0,fx,{\an5\pos(120,995)\c&HFFFFFFF&\3c&HFFFFFFF&\bord4\blur6\t(0,48,0.5,\fscx150\fscy150\c&HFFFFFF&\3c&HFFFFFF&)\t(48,120,\fscx100\fscy100\c&HFFFFFFF&\3c&H0000FF&)\fad(0,300)}",MID(A1,1,1),"
Dialogue: 1,0:00:00.04,0:00:00.76,Default,,0,0,0,fx,{\an5\pos(172,916)\c&HF5B900&\bord0\blur3\fscx0\fscy0\t(0,637,\fscx99\fscy99\alpha&HFF&)\p1}m 30 0 b 0 0 0 44 30 44 b 60 44 60 0 30 0",MID(A1,1,1),"
Dialogue: 1,0:00:00.24,0:00:00.96,Default,,0,0,0,fx,{\an5\pos(102,927)\c&HE61914&\bord0\blur4\fscx0\fscy0\t(0,835,\fscx91\fscy91\alpha&HFF&)\p1}m 30 0 b 0 0 0 44 30 44 b 60 44 60 0 30 0",MID(A1,1,1),"
Dialogue: 1,0:00:00.24,0:00:00.96,Default,,0,0,0,fx,{\an5\pos(102,927)\c&HE61914&\bord0\blur4\fscx0\fscy0\t(0,835,\fscx91\fscy91\alpha&HFF&)\p1}m 30 0 b 0 0 0 44 30 44 b 60 44 60 0 30 0",MID(A1,1,1))

请问各位大咖，粘贴能正常 使用的 内容 ，谢谢！！