Re: Sorting imported text
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Sun, 09 Oct 2005 07:35:32 -0500
Sometimes, when you copy|paste from a web site, you'll get some HTML stuff in
the cell--Non-breaking spaces in HTML often cause the problem you're seeing.
You may want to try David McRitchie's routine to clean that stuff up:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Leslie wrote:
>
> I have a spreadsheet into which I've imported a great deal of data in two
> columns only. I set out rows one, three and five of hundreds of such rows.
> The cells in column A consist of place names. (The "C" following the place
> name stands for "City", the "A" for "Area".) The cells in column C represent
> the population of the city or area, as the case may be. I've formatted the
> cells in column C as numbers.
>
> Albury (C) 44887
>
> Armidale Dumaresq (A) 24596
>
> Ashfield (A) 40258
>
> I want to sort the placenames in order of their population from highest to
> lowest, showing their populations as well. I tried to sort the data on
> column C in descending order, but nothing happened.
>
> I fear that may be because of my method of importing the data. I got it by
> first downloading the text only of a Web page which had the data, thoughnot
> in a table. I then transferred the text to the worksheet.
>
> Is there something I should be doing which would permit me to sort the data
> as I want?
>
> Thank you.
--
Dave Peterson
.
- Follow-Ups:
- Sorting imported text
- From: Leslie
- Sorting imported text
- References:
- Sorting imported text
- From: Leslie
- Sorting imported text
- Prev by Date: Macro to run upon Workbook opening
- Next by Date: Re: How to create combo box on whole column fastly?
- Previous by thread: Sorting imported text
- Next by thread: Sorting imported text
- Index(es):
Relevant Pages
|
