0

I would like to sort a colomn of my excel file following a "word".

I mean to sorting by word. Is it possible in Microsoft Office Excel 2007 ?

If I have :

AHG hELLO

BFF ...

FOO ...

AHG HI

DCE ...

and I sort by the word "A" , I will get :

AHG hELLO

AHG HI

BFF ...

FOO ...

DCE ...

1
  • Seriously?  Excel is sorting “FOO” before “DCE”?  That’s abnormal;  what did you do to get that to happen?  Or are you saying that it’s behaving rationally, and sorting “DCE” before “FOO”, but you want “FOO” before “DCE”?  If so, why? Jan 11, 2017 at 22:03

1 Answer 1

0

If you mean sorting alphabetically, then the answer is yes.

If there are text entries in the column you're sorting, and you have turned on Filter (In the Data tab), then you will be able to sort alphabetically just as easily as you can sort numerically.

UPDATED for question update:

Alphabetically includes words, so the answer would still be "yes" unless you mean an arbitrary arrangement different than strict alphabetical, in which case the answer would be "no".

Excel sorts alphabetically and numerically and alphanumerically (in which case the numbers go first in a descending sort).

Alphabetical sorting does handle words. Spaces occur after "z" and so a multi-word string in a field will occur after any single word strings with the same starting word.

If this still does not answer your question, perhaps you could use your sample data and actually sort it, and then show us the output as Excel has sorted it, and then the way you'd like it to be sorted instead.

3
  • not alphabetically
    – IamaTacos
    May 21, 2015 at 13:32
  • A stands for a Word
    – IamaTacos
    May 21, 2015 at 13:32
  • I updated the question .
    – IamaTacos
    May 21, 2015 at 13:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .