How do I alphabetize a column or cell?

Hi momluvs3Ido,

Here's a function that will find the Alpha from an Integer input:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

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.

Select the relevant range, Data > Sort

Or maybe going beyond Column Z

Formula:

Please Login or Register  to view this content.

Here is a replacement for the function I posted above which is incorrect:

Please Login or Register  to view this content.