Question

excel中，如果D1=L-12345，A1=L，B1=无字符，C1=23；如果D1=1-7-20304，A1=1，B1=7，C1=03

Answer 1

A1输入：

=IF(D1="L-12345","L",IF(D1="1-7-20304","1",""))

 

B1输入：

=IF(D1="L-12345","",IF(D1="1-7-20304","7",""))

 

C1输入：

=IF(D1="L-12345","23",IF(D1="1-7-20304","03",""))

 

追问

如果D1=7个字符，A1=第一个字符，B1=无字符，C1=第四、五个字符；如果D1=9个字符，A1=第一个字符，B1=第三个字符，C1=第六、七个字符

追答

A1:
=IF(LEN(D1)=7,LEFT(D1,1),IF(LEN(D1)=9,LEFT(D1,1),""))

B1:
=IF(LEN(D1)=7,"",IF(LEN(D1)=9,MID(D1,3,1),""))

C1:
=IF(LEN(D1)=7,MID(D1,4,2),IF(LEN(D1)=9,MID(D1,6,2),""))