How to code a macro to sort a list of string?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

In cell A2, there is char 2328050010001023841.
The format for those value must be string instead of number based on Excel's
specifications,
which has 15 digit precision.

If I get a list of string under A column, does anyone have any suggestions
on how to sort it in ascending order based on macro coding?
Thank everyone very much for any suggestions
Eric
 
In cell A2, there is char 2328050010001023841.
The format for those value must be string instead of number based on Excel's
specifications,
which has 15 digit precision.

If I get a list of string under A column, does anyone have any suggestions
on how to sort it in ascending order based on macro coding?
Thank everyone very much for any suggestions
Eric
Click to expand...

Hi

Range("A2:A100").Sort Key1:=Range("A2"), Order1:=xlAscending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

BTW: To enter numbers as text, enter ' (single quotation sign) before
the number.

Regards,
Per
 
Eric said:
In cell A2, there is char 2328050010001023841.
The format for those value must be string instead of number based on Excel's
specifications,
which has 15 digit precision.

If I get a list of string under A column, does anyone have any suggestions
on how to sort it in ascending order based on macro coding?
Thank everyone very much for any suggestions
Eric
Click to expand...


See http://www.standards.com/index.html?Sorting
 
Thank everyone very much for suggestions
Could you please give me more information on where to put those codeing?
I would like to keep column A untouch, and show the sorted results on column
B.
Do you have any suggestions?
Thank everyone very much for any suggestions
Eric
 
Back
Top