sort cells with "mixed content" (number + text) like numbers

[PeteWright]

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

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	123	123
3	234	123 456
4	345	123 ABC
5	456	234
6	123 456	234 567
7	234 567	345
8	345 678	345 678
9	123 ABC	456
10	456 XYZ	456 XYZ
Sheet6

Cell Formulas
Range	Formula
B2:B10	B2	=SORTBY(A2:A10,TEXTBEFORE(A2:A10," ",,,1))
Dynamic array formulas.

 

[Special-K99]

Yes, use a helper column
in B1
=LEFT(A1&" ",7)
The above aligns each row of data
and copy down

Now sort on column B