公式: =LEFT(C7,1)&MID(SUBSTITUTE(PROPER(C7),"_",""),2,100) 举例说明: 转载于:https://www.cnblogs.com/kdx-2/p/10974180.html