姓名中間 改 "O" (13769)

B2=LEFT(A2)&"O"&IF(LEN(A2)=2,"",RIGHT(A2))

C2=REPLACE(A2,2,MAX(LEN(A2)-2,1),REPT("O",MAX(LEN(A2)-2,1)))

C2另解=LEFT(A2)&REPT("O",LEN(A2)-2)&IF(LEN(A2)=2,"O",RIGHT(A2))

C2另解=LEFT(A2)&"O"&RIGHT(REPT("O",9)&RIGHT(A2),LEN(A2)-2)