>Select all the numbers.

>Then Edit>Replace hold the Alt key and use
>the number keypad on the right of the keyboard
>to enter 0160 as the "Find what". Be sure
>the "Replace with" is empty. Replace All.

>That is a common HTML character that looks
>like a space.

>Alternatively, download Refinate and use it
>for free to convert to numbers by dragging
>and clicking (apply Refinate's Number-Values action).

>--Brian Taylor
>Refinate (C)2001, 20 free trials.
>Click to: Rearrange Cells or Cell Content,
>Find Duplicates, Count Items, Import, much more.
>www.adetaylor.com

>"George" <george39672...@yahoo.com> wrote in message
>news:112b301c21a32$52c03390$b1e62ecf@tkmsftngxa04...

>> Mr. Taylor,

>> Your suggestion works! Terrific! Thank you!

>> Just one followup question:
>> The 'sort' function creates strange results on only
>one
>> particular column (market capitalization) where it
>appears
>> all the 'values' are treated as characters.
>> Sampling of data after a sort is 1.9B, 10.7B, 138.4B,
>> 14.2B, 2.3B, 247.0M, etc. Note the 'B' is billions and
>'M'
>> is
>> millions.
>> How can one convert all these 'values' into the proper
>> numbers?

>> Thank you again,

>> George

>> >-----Original Message-----
>> >Try dragging to select the HTML worksheet at yahoo
>> >and right-click>Copy. Open a fresh Excel worksheet
>> >and paste it.
>> >It seems to work for me.

>> >--Brian Taylor
>> >Refinate (C)2001, 20 free trials.
>> >Click to: Rearrange Cells or Cell Content,
>> >Find Duplicates, Count Items, Import, much more.
>> >www.adetaylor.com

>> >"George" <george39672...@yahoo.com> wrote in message
>> >news:112b501c21a18$94d59dc0$9be62ecf@tkmsftngxa03...
>> >> Hello folks,

>> >> I'm trying to download data from a webpage into an
>> >excel
>> >> sheet. The resultant excel sheet
>> >> does not contain the data in the appropriate
>> >rows/columns.

>> >> System:
>> >> Microsoft Office 2000 Professional
>> >> Internet Explorer  version 5.00 with update SP2

>> >> 1) access to webpage
>> >http://biz.yahoo.com/p/_noncyc-
>> >> bevnon.html
>> >> 2) click on "Download Spreadsheet"
>> >> 3) save as  filename 'abc' with format 'txt' and
>> >> encoding 'Western European (Windows)'.
>> >> This file already has the data mixed up. (see all
>> >errors a
>> >> to e below)
>> >> 4) At excel, menu 'Data', submenu item 'Get
>External
>> >> Data', with delimitor(s) of a comma selected.

>> >> Errors
>> >> The result contains the following errors:
>> >> a) The first column does not alway contain the
>entire
>> >> company's name.
>> >> b) The last column does not always contain one
>piece
>> >of
>> >> info. Sometimes it contains a value and a part of
>the
>> >> company's name.
>> >> c) The company's name enclosed with double quotes
>> >> d) Some second columns contains the word 'In.' or
>> >'S.A.'
>> >> subsequent data are right shifted by one column.
>> >> e) Some rows only contain a partial name and the
>> >> associated data is found in the subsequent row.

>> >> I suspect the company's name are too long and/or
>> >contain
>> >> special characters (periods, comma,
>> >> hyphen). Also, there is possibly no carriage return
>or
>> >tab
>> >> key at the end of each row.

>> >> How can one create an excel sheet that contains a
>> >given
>> >> company and all its data on a single row
>> >> (as in the original webpage above, but with the
>excel
>> >> capabilities to delete rows and sort by several
>> >variables)
>> >> at the same time.)? Note: the header line is nice
>to
>> >have
>> >> but is not important as one can manually
>> >> enter this with little time.

>> >> Please show a simple procedure to achieve the
>correct
>> >data.

>> >> Your assistance is most appreciated.

>> >> Thank you,

>> >.