I think you will need to impert them into one sheet.
then you can select only even rows through many methods
helper column with =mod(row(),2)+1
select the helper column copy and paste special values
select all and sort by helper column
select all the rows with 2 in the helper column and cut and paste into sheet 2


"MikeD1224" wrote:

I have a .txt file that I need to import into Excel as fixed length. I need
to import all the odd rows from the .txt file into worksheet 1 and then
import all the even rows from the .txt file into worksheet 2.

Any ideas on how I would do this?

Thanks,

Mike