Hi,

Experts i need help on such data that delimter form.txt in one cell not in other cells. How to add in other cells.

Example
Erp# Name F.Name Designation D.O.J Type
223344 Naveed mumtaz Supervisor 12-04-15 Permanent
224200 Shafiq Irshad Supervisor 12-06-15 Permanent
224504 Zahid Iqbal Helper 21-03-12 Permanent


Data is in A1:A4 just 4 cell in but i need to proper columns and rows data.....with formula

Thanks and Regards,
Navi_G