Re: Text to Columns - delimited

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

Regards,
Fred.

"megankathryn" <megankathryn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:EE244B98-02C2-4436-BD68-CFD1990F966D@xxxxxxxxxxxxxxxx
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" wrote:

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

megankathryn wrote:
>
> 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


.

Relevant Pages

  • Re: Text to Columns - delimited
    ... Then the wizard looks like the data|text to columns wizard. ... megankathryn wrote: ... step in the wizard is always choosing the option that the first row ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.misc)
  • Re: Importing Excel Data - Recognizing Headers
    ... some VBA code that the macro would call. ... workbook somewhere on their individual network. ... to see that first row as having headers in them. ...
    (microsoft.public.access.externaldata)
  • Re: How can I import multiple .csv files into access?
    ... Access can do this but it takes a litle time and works a lot smoother if you have at least intermediate level experience. ... Use the CLI copy command to concatenate the files into one file - if the files contain headers - you can open the file with notepad, use the Ctrl-F search tool to find the headers - and delete all but the very first row of headers. ... If you are at all familiar with the old DOS days ways, and using batch files, then you know exactly what I am talking about. ...
    (microsoft.public.access.externaldata)
  • Re: How to display database table data in a html table.
    ... to read and display the headers and the first row of the table and it ... foreach ($allheaders as $header) ...
    (comp.lang.php)
  • Re: Importing Excel Data - Recognizing Headers
    ... to see that first row as having headers in them. ... I have an Excel macro that creates a workbook with column headings in row ...
    (microsoft.public.access.externaldata)