hi,
i have a notepad file and i am able to import the data in excel.
now, this notepad file contains a trigger word "end" at several places.
while importing, can i have some option in excel which will create a new sheet when this particular trigger word is found.