Text to Columns - delimited

[megankathryn]

I am trying to use the text to columns function (which I always use... almost
a daily basis) and today the options are different.

It is not even giving me the option to click "columns contain headings"

PLEASE help???

 

[Dave Peterson]

You sure you didn't see that option when you were sorting?

 

[megankathryn]

Yes... this is somethinig I do on a very regular basis. I highlight the
column and it tells click "text to column" - choose delimited and the second
step in the wizard is always choosing the option that the first row contains
headers. I am getting a totally different box this time.

 

[Dave Peterson]

I think you're mis-remembering.

Yes... this is somethinig I do on a very regular basis. I highlight the
column and it tells click "text to column" - choose delimited and the second
step in the wizard is always choosing the option that the first row contains
headers. I am getting a totally different box this time.

 

[Fred Smith]

"First row contains headers" is in Sort, not Text To Columns.

Regards,
Fred.

 

[megankathryn]

well... no it isn't - I use this function daily and used it yesterday.
Thanks anyway...

 

[Dave Peterson]

Maybe you weren't using data|text to columns...

Is it possible that you were using File|Open (a text file) or
data|import external data

Each of those has a "Start import at row" option.

Then the wizard looks like the data|text to columns wizard.

well... no it isn't - I use this function daily and used it yesterday.
Thanks anyway...