PeteWright
Well-known Member
- Joined
- Dec 20, 2020
- Messages
- 506
- Office Version
- 365
- Platform
- Windows
- Mobile
Hello,
I would like to sort some data, but it's mixed (numbers, numbers + text).
To keep it simple here's some dummy data:
123
234
345
456
123 456
234 567
345 678
123 ABC
456 XYZ
Right now numbers and everything else is sorted separately. What I would like to achieve is the following order:
123
123 456
123 ABC
234
234 567
345
345 678
456
456 XYZ
I wonder if this is even possible. I also wouldn't mind helper cells.
Many thanks in advance
I would like to sort some data, but it's mixed (numbers, numbers + text).
To keep it simple here's some dummy data:
123
234
345
456
123 456
234 567
345 678
123 ABC
456 XYZ
Right now numbers and everything else is sorted separately. What I would like to achieve is the following order:
123
123 456
123 ABC
234
234 567
345
345 678
456
456 XYZ
I wonder if this is even possible. I also wouldn't mind helper cells.
Many thanks in advance