20/08/06 22:26:52 i3jWc/a8.net
生データセルから直接変換しようとすると,式が長くなります.
例えば最初の頃は
=IF(A22<>"",V22&"人目 "&TEXT(W22,"M月D日")&" "&$Z$4&IF(L22<>"調査中"," "&L22,"")&IF(AND(H22="調査中",J22="調査中"),""," "&IF(H22<>"調査中",ASC(H22),"")&IF(J22<>"調査中",J22,""))&IF(N22<>""," "&N22,"")&IF(R22<>""," "&R22,"")&IF(P22<>""," "&ASC(P22),"")&IF(Q22<>""," "&ASC(Q22),"")&IF(O22<>""," "&ASC(O22),"")&IF(M22<>""," "&M22,"")&" "&X22)
でも,中間の項目処理用のセルを介せば少し綺麗に書けます.
だいぶ短くなってきましたが,その分メモリリソースも大きくなりますけど