sorting abbreviations

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
 
J

JE McGimpsey

one way:

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

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

and sort on that column.
 
A

Armeeabteilung

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.
 
J

JE McGimpsey

If you used the formula I gave her, there won't *be* any abbreviations
with dots in the sort column.
 
Top