Convert csv files in folder to xlsm

Hello everybody
I need to convert files in specific folder from csv to xlsm and after conversion to split data to columns separated by the delimiter ;
Thanks advanced for help

Any idea about this issue?

Hello Yasser,

I don't have the Arabic language pack installed for Excel but I do see the semi-colons in the text.

Will you be adding the VBA code to this workbooks at a later time?

Thanks a lot for offering to help Mr. Leith
Here's one cell

73102;ابتدائية أبا الصبان;بنين;المرحلة الابتدائية;حكومي;نهاري;النظام العام;مكتب التربية والتعليم بالحائط;الثالث الابتدائي;قسم عام;1

There is ; as you see

Hello Yasser,

Thanks for the showing it in Arabic. Does your workbook show columns Right to Left or Left to Right?

The workbook shows columns Right to Left ....

Hello Yaaser,

I thought it would. Just checking to be sure.

I didn't get what you mean ..
The workbook (csv file) shows columns from right to left ..
In fact data in csv file existed in one column and I need to convert to xlsm then split the data according the delimiter ;
Thanks a lot

Hello Yasser,

Do want to convert only the files in the parent folder or all files in the parent folder and it's subfolders?

I want to convert all file in the parent folder and its sub folders ..and the results to be adjacent to their original files (in the same folder or sub folder)