Cell sorting Excel

Occasional Visitor


I need to sort these cells from left to right and continue the rows below, same order as the red numbers.

It's the second line in the cells that I want to sort, the QJ numbers.

The red numbers don't need to be in order and I don't want to separate/remove the red numbers from their cells.

How do I do this?


1 Reply

Do the red numbers need to be sorted with the QJ numbers or can they just stay in sequential order as they are currently? I'd like to take a stab at this, it's going to be a VBA solution though. Can you post the excel file of the screenshot you uploaded?

Related Conversations
Please Fix File Sorting by Name in Ms Teams
HYPERVELOCITY in Microsoft Teams on
11 Replies
Pivot Table not sorting
FRobinson25 in Excel on
1 Replies
not able to type number and text in same cell?
Deleted in Excel on
2 Replies
Sorting data - by reference
Laura Backshell in Excel on
8 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies