Let me explain what the formula above means: UPPER(LEFT(C2,1)) converts the first letter of C2 cell to capital. REPLACE function is used to make ...
確定! 回上一頁