Grammar
INDEXOF(str1,index)
Returns the character in str1 at the position specified by index.
Parameter 1
str1
Character string 1
Parameter 2
index
Position of the returned character.
The value of index starts from 0.
The INDEXOF function returns text-type data.
The function supports two parameters, between which the first is of any type and the second is a number.
For example, if you want to filter out the Store Code field that end with 3, the INDEXOF function can be used.
Choose Filter > Add Formula, and enter INDEX(Store Code,6)="3", as shown in the following figure.
More examples:
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy