EXCEL里怎么将这种数据进行转换?

2025-02-26 08:21:07
推荐回答(2个)
回答1:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,D3,E3),D4,E4),D5,E5),"""",""),"{",""),"}","")

回答2:

可以试下写VBA的宏代码.