I've now moved from ferns to woody plants. Same problem.
Is it possible for me to post a copy of the workbook page?
No, I haven't copied anything from the web. And I looked to make sure that blank spaces weren't lurking.
Huh...that's interesting. I just noticed something that might be causing the problem, but don't know what is causing it.
I copied and pasted a set of cells. Although in the workbook, they are all separate cells and I need to tab or click to get from one to the next, when I copy and paste, a number of them are showing the text of the cells running together without spaces.
Note the PiceaabiesGregoryana Parsonii on the first line. The other Picea abies are at the bottom and have a space between "Picea" and "abies."
Then again, that doesn't fully explain why Piceaspecies is before Piceajezonensis. But, it might give a clue????
Picea abies Gregoryana Parsonii
Picea glauca Densata
Picea glauca Yukon Blue
Picea glauca Jean's Dilly
Picea glauca? cultivar?
Picea species, unknown medium; globular
Picea jezoensis hondoensis
Picea koyamae
Picea mariana Aureo marginata
Picea omorika
Picea omorika
Picea omorika
Picea omorika
Picea orientalis Losely
Picea orientalis Gaul Aurea
Picea pungens Pendula
Picea pungens Henry B Fowler
Picea pungens Henry B Fowler
Picea pungens Hunnewelliana
Picea pungens Hunnewelliana
Picea abies Nidiformis
Picea abies Nidiformis
Quote:
Originally Posted by Ron Rosenfeld[_2_]
On Sun, 22 Dec 2013 19:24:34 +0000, walkingfern wrote:
Hi,
I'm trying to sort a spreadsheet of fern information alphabetically,
first by column A (genus) and then by column B (species). Columns C-F
contain additional information.
I've selected data sorting in the order of Column A then Column B.
However, it consistently puts some items out of order for column B,
making it difficult for me to check the species information. I've double
checked for extra spaces, there are no extra characters. I don't
understand what's happening.
Example:
Sorted alphabetically, Dryopteris marginalis will be listed before
Dryopteris goldiana.
Or it will list
Dryopteris marginalis
Dryopteris marginalis
Dryopteris intermedia
Dryopteris marginalis
Dryopteris marginalis.
Can anyone help? Thank you!
I don't think we'll be able to help without a copy of the dysfunctional workbook. I see nothing apparent from what you've posted to explain this behavior. Hidden (non-printing) characters are the most likely explanation. Especially if you are copying this information from the Web, the possibility of <nbsp characters can mess up your sorting.
|