hello,

I have a dataset like this:

18abc.xls
18abd.xls
18ace.xls
19abi.xls
19bce.xls
20cde.xls

And I want to split it to something like this:

18 abc
18 abd
18 ace
19 abi
19 bce
20 cde

can you help me? I know a bit of VBA but would prefer to keep it in excel.

Thanks