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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.