dictionary

[ahhmedd]

Hi,

I want to list words according to their backwards letters (!) i.e. as if the word begins from the right not from the left, so that in the list ( walking, racing, swimming, dreaming ) the order I want is the following ( racing, walking, dreaming, swimming ) they are listed alphabetically according to the last letters.

What formula can I use? I am using excel 2007.

Any help is highly appreciated.

 

[Luke M]

Check out the UDF here (includes installation instructions):

http://www.ozgrid.com/VBA/ReverseCell.htm


Then you can create a helper column with the ReverseCell formula, and sort your data based on that.

 

[ahhmedd]

Thanks dear Luke M. This is a great help of you.

 

[Luke M]

You're very welcome. =)

 

[abrarssdd]

Awesome!! It’s just what I need!! Thanks!............


Dictionary

 

[Jazzy222]

Thanks for sharing very useful info............


English to Urdu Dictionary