Windows 10: Excel, windows version 10 - Data - Text to columns - wizard box not appearing that appears...

I am using an external source to pull data and my colleague is using Windows 11 pro and I am using windows 10 prnce dataset is loaded into a raw data tab. We then go to the data tab and then the text to columns tab, in my colleagues tab a wizard box appears and in this wizard it allows you to specify columns which we desperately need. what I get in my version of excel is a very basic box that does not allow a wizard to appear.which in turn does not allow you to specify columns.We need this, how can we fix this and allow a wizard box to appear

:)

 

How to get to Text Import wizard - trying to change to Excel, delimited

Open Excel > File > Open > Browse > Select the required Text or csv file > This will kick off Text to Columns wizard

OR

Select the column in Excel > Data tab > Text to columns

 

Text box appears over File Explorer while scrolling long lists

I agree with Hearsepilot So here's a pic of how to do what was suggested.

 

Extraneous column and row headings appeared in Excel

Two rows and two columns appeared in a worksheet when Excel updated. They are above the Column headings and to the left of the row headings, both labeled 1 and 2. If I click on 2, I get the normal worksheet.

If I click on 1, I get extreme parts of the worksheet below or to the right of the area I'm working on. The worksheet is designed to expand by columns by adding data to the right, so the sum functions contain references way to the right.

How do I get rid of these additional headers? What are they? They clog up the display.