學生成績單

在基本資料，C2
=VLOOKUP(A2,查表!$A$1:$B$12,2,FALSE)

---
姓氏-藝名

=LEFT(B2,1)
=RIGHT(B2,1)
=LEFT(B2,1)&"Ｏ"&RIGHT(B2,1)
---
=IF(LEN(B2)=4,LEFT(B2,2),LEFT(B2,1))&"Ｏ"&IF(LEN(B2)=2,"",RIGHT(B2,1))


---
電子郵件@

=FIND("@",H2)
=MID(H2,I2+1,LEN(H2)-I2)