Dear All,

Could someone can help me with this....
I need to extract file name example ABC-01.xls in to ABC-01 only what method i could use on this?
Could anyone help me please!!!

Thanks & Best Regards

Use split function and get only ABC-01

Or you can use Left() function to get it.