Sort in Excel

Question

Sort in Excel

Anonymous

Hi.

How can i sort a large row of cells consisting of letters and numbers. For example.

A1-A100

B1-B100

........

L1-L200

M1-M200

Kind regards

Jepper

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

1 answer

Answer 1

Hi Jepper_002, hope you're doing well. I’m Ian, and I’m happy to help you today.

In this case you will be needing an intermediate column. since the sorting for Alphanumeric is this one, A10 ordered first follow by A2.

For the intermediate column we change your data from A2 to A002 (since in your sample data the highest value is 100)

Example your data is in column A, then your column B will be your intermediate column with this formula.

=LEFT(A1,1) & TEXT(SUBSTITUTE(A1,LEFT(A1,1),""),"000")

Afterwards you can now sort the column B with expand selection.

This is a user-to-user support forum and I am a fellow user.

I hope this helps, but please let me know if you need anything else.

Share via

Sort in Excel

1 answer