求助求大神帮助

我要想的是参数化就是我只改A项(用的多)，其它都会跟着变最后我取最终数据就好了 如果一次一次分开来，数据多就很麻烦

=LET(a,TOROW(TEXTSPLIT(A9,"X","x"),3),b,TEXT(a/25.4,"0.000"),HSTACK(a,b,TEXTJOIN("X",,b)))
=TRIM(MID(TEXTJOIN(REPT(" ",99),,TRIM(MID(SUBSTITUTE(SUBSTITUTE($A9,"x","X"),"X",REPT(" ",99)),{1,2,3}*99-98,99)),TEXT(MID(SUBSTITUTE(SUBSTITUTE($A9,"x","X"),"X",REPT(" ",99)),{1,2,3}*99-98,99)/25.4,"0.000"),TEXTJOIN("X",,TEXT(MID(SUBSTITUTE(SUBSTITUTE($A9,"x","X"),"X",REPT(" ",99)),{1,2,3}*99-98,99)/25.4,"0.000"))),COLUMN(A9)*99-98,99))

=IF(COLUMN(A1)<4,INDEX(EVALUATE(SUBSTITUTE(SUBSTITUTE("{"&$A2&"}","X",","),"x",",")),,MOD(COLUMN(C3),3)+1),IF(COLUMN(A1)<7,INDEX(TEXT(EVALUATE(SUBSTITUTE(SUBSTITUTE("{"&$A2&"}","X",","),"x",","))/25.4,"0.000"),,MOD(COLUMN(C3),3)+1),TEXTJOIN("X",1,TEXT(EVALUATE(SUBSTITUTE(SUBSTITUTE("{"&$A2&"}","X",","),"x",","))/25.4,"0.000"))))

分成三段做. 分别是这三公式