sorting abbreviations

  • Thread starter Thread starter Armeeabteilung
  • Start date Start date
A

Armeeabteilung

I have a long list of abbreviations.
Some letters have periods (full stops) after each of them, i.e
"A.K.K."
others have periods (full stops) at the end of the abbreviation, i.e
"abbr."
When I sort, "A.K.K." comes before "abbr."
How do I get the correct alphabetical sorting, i.e. "Abbr." befor
"A.K.K."?

The same question, but applying to empty spaces.

Thank you for your time and attention
 
one way:

Assume your abbreviations and acronyms are in column A. In another
column, enter

=SUBSTITUTE(SUBSTITUTE(A1,".","")," ","")

and sort on that column.
 
Tried that just now.

Does not work.

The abbreviations with dots remain at the top of the column to be
sorted.

Now what?

The abbreviations are indeed in column A, which needs to be sorted -
the definitions are in columns B and C.
 
If you used the formula I gave her, there won't *be* any abbreviations
with dots in the sort column.
 
Back
Top