I have an funny problem....
if( FindOneOf( colA ,'/')>0, SubField( colA ,'/',2), 'Others') as Type_Val
With a XLS file, no problem.
With the same file saved as XLSX format, the function "FindOneOf" not works, the caracter " / " has never found....
|However, the cell format is the same (no specific) in this two versions,|
For example, colA contains data as : "ABCDEF/11"