我有以下来源：
1 PK5291 09:32:28:17 00:00:40:00 00:00:00:00 00:00:40:00
我想将其转换为下面的模板：
PK5291 N C 2020/02/27 09:32:28 D 00:01:00:00 0 N N
PK5291当到之间的空间N是TAB
我尝试了下面的公式但没有成功，我的错误在哪里？
=CONCATENATE(B8,CHAR(9),"N","CHAR(9)","C","CHAR(9)","2020/03/08 C8","CHAR(9)","D","CHAR(9)",D8,"CHAR(9)",0,"CHAR(9)","N","CHAR(9)","N")