Excel 2010 open semi-colon separated file

Before excel 2010, all I had to do is open excel, select OPEN, choose the file, and excel would prompt on the format type with options before opening. I could choose comas, tabs, spaces, semi-colons, or anything I wanted. It would then just work. All was well.

Where the heck are these options in excel 2010. I open excel, select TXT file type, and it just opens without prompting format. I've tried other format selections without luck. The data comes in all combined in rows. The columns are not created.

I use to do this a lot. Something is much different.

thanks in advance.

Thank you. That worked. Why did they change that? DANG!