How to "From Excel to Text document with predefined spaces"

[zzaakk10]

Hi all,
I heard from a friend that this forum is very useful.
I am facing a problem, as i am not that good in programming.
i have one excel document containing information of employees, for some purpose i need to convert that information to a text document with some special format which will be loaded in Retail software. unfortunately the number of employees is huge that i can not do it manually or it will take months.

Employee Information to be loaded transferred to text document:
employee code, store code, employee name, surname 1, surname 2, post code.

Format in text document:
Employee code(8 digits) 8 blanks, then Store Code(4 digits) 3 blanks, then Employee name(20 characters) no blank, then Surname1(20 characters) no blank, then Surname2(20 characters) 15 blanks, then Post code. After this next line and same information for next employee.

You can see the attached pic also for what format i want in txt document.
If anybody can help, i will be really thankful.

Thanks