there is text, not numbers, in the cells. But I see 'M's and 'B's, which are
text, too. Here's how to change them into numbers that Excel understands:
Select the numbers.
Do a find and replace, and replace B with E9, then replace M with E6.
Billions are 10^9 or 1E9, and Millions are 10^6 or 1E6. This converts the
non-numbers into numbers (I did a little test just now), so they can be
>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).
>Refinate (C)2001, 20 free trials.
>Click to: Rearrange Cells or Cell Content,
>Find Duplicates, Count Items, Import, much more.
>"George" <george39672...@yahoo.com> wrote in message
>> Mr. Taylor,
>> Your suggestion works! Terrific! Thank you!
>> Just one followup question:
>> The 'sort' function creates strange results on only
>> particular column (market capitalization) where it
>> 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
>> How can one convert all these 'values' into the proper
>> Thank you again,
>> >-----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.
>> >"George" <george39672...@yahoo.com> wrote in message
>> >> Hello folks,
>> >> I'm trying to download data from a webpage into an
>> >> sheet. The resultant excel sheet
>> >> does not contain the data in the appropriate
>> >> System:
>> >> Microsoft Office 2000 Professional
>> >> Internet Explorer version 5.00 with update SP2
>> >> 1) access to webpage
>> >> 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
>> >> Data', with delimitor(s) of a comma selected.
>> >> Errors
>> >> The result contains the following errors:
>> >> a) The first column does not alway contain the
>> >> company's name.
>> >> b) The last column does not always contain one
>> >> info. Sometimes it contains a value and a part of
>> >> company's name.
>> >> c) The company's name enclosed with double quotes
>> >> d) Some second columns contains the word 'In.' or
>> >> 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
>> >> special characters (periods, comma,
>> >> hyphen). Also, there is possibly no carriage return
>> >> key at the end of each row.
>> >> How can one create an excel sheet that contains a
>> >> company and all its data on a single row
>> >> (as in the original webpage above, but with the
>> >> capabilities to delete rows and sort by several
>> >> at the same time.)? Note: the header line is nice
>> >> but is not important as one can manually
>> >> enter this with little time.
>> >> Please show a simple procedure to achieve the
>> >> Your assistance is most appreciated.
>> >> Thank you,