Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Sort text column including 1st cell

If I sort a column of numbers all is well but not when I have a column text.

I have a column of text that looks like this (note I type a column of text below but it displays as a line of text???)

ZZZ DDD BBB

If I choose Data > Sort > Ascending the column is sorted EXCEPT that the first cell is not included and remains unchanged, resulting in:

ZZZ BBB DDD

How can I force the first cell to be included in the sort?

Sort text column including 1st cell

If I sort a column of numbers all is well but not when I have a column of text.

I have a column of text that looks like this (note I type a column of text below but it displays as a line of text???)

ZZZ DDD BBB

If I choose Data > Sort > Ascending the column is sorted EXCEPT that the first cell is not included and remains unchanged, resulting in:

ZZZ BBB DDD

How can I force the first cell to be included in the sort?