To split a text string at a specific character with a formula, you can use the TEXTBEFORE and ... FIND returns 11, so the result after subtracting 1 is 10.
確定! 回上一頁