Hello Everybody! Please help me to export notepad data into excel 2010 Format of data in notepad Heading1 Sometext (varing length) Heading2 Sometext (varing length) Heading3 Sometext (varing length) Heading4 Sometext (varing length) Heading5 Sometext (varing length) I want Heading 1,2,3,4,5 all in seperate column in excel 2010 and then loop whole process as i have 100 such notepad files I want all 100 files data in one excel worksheet only under heading 1,2,3,4,5 Kindly help! Thanks

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Help Me Please! Export data from notepad to Excel 2010

Thread starter darkhorse11
Start date Sep 19, 2011
Tags

notepad excel

darkhorse11

New Member

Sep 19, 2011

Hello Everybody!
Please help me to export notepad data into excel 2010
Format of data in notepad
Heading1
Sometext (varing length)
<space>
Heading2
Sometext (varing length)
<space>
Heading3
Sometext (varing length)
<space>
Heading4
Sometext (varing length)
<space>
Heading5
Sometext (varing length)

I want Heading 1,2,3,4,5 all in seperate column in excel 2010

and then loop whole process as i have 100 such notepad files

I want all 100 files data in one excel worksheet only under heading 1,2,3,4,5

Kindly help!

Thanks