Text to Columns - delimited

  • Thread starter Thread starter megankathryn
  • Start date Start date
M

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???
 
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.
 
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.
Click to expand...
 
well... no it isn't - I use this function daily and used it yesterday.
Thanks anyway...
 
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...
Click to expand...
 
Back
Top