I'm trying to alphabetize my column. I'm sure it's easy but I can't seem to find it.
Thanks
I'm trying to alphabetize my column. I'm sure it's easy but I can't seem to find it.
Thanks
Hi momluvs3Ido,
Here's a function that will find the Alpha from an Integer input:
Directions for running the routine(s) just supplied![]()
Please Login or Register to view this content.
Copy the code to the clipboard
Press ALT + F11 to open the Visual Basic Editor.
Select “Module” from the Insert menu
Type "Option Explicit" then paste the code under it
Then you can use it either in the worksheet or by code
To use in worksheet: write =GetAlpha(A1) or whatever cell your value is in
Or write =GetAlpha(147) to find the Alpha for column 147 etc.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Select the relevant range, Data > Sort
Entia non sunt multiplicanda sine necessitate
Hi,
Or you can try typing the letter A in cell A1, and in cell B1 put formula =CHAR(CODE(A1)+1) and drag across as far as you need, should work until column Z
Thanks.
Or maybe going beyond Column Z
Formula:
Please Login or Register to view this content.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Here is a replacement for the function I posted above which is incorrect:
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks