"FindOneOf" : difference with Excel Files .XLS and .XLSX ???

[#1]

Hi,

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"

an idea?

many thanks

[marcus_sommer]

Will the char "/" loaded from the xlsx - how looks the field-values (without transforming) after loading.

- Marcus