Sort With Number and Word

[amir0914]

hi all, i have a column of number and Word, how can i sort this Column same this image(column C) :

My Numbers are in Column A and i Want to sort like column c.
Thanks in advanced.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-programming-vba-macros/1226792-sort-with-number-and-word.html

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Jonmo1]

You can make a custom list in File - Options - Advanced - General - Edit Custom Lists.

 

[markmzz]

hi all, i have a column of number and Word, how can i sort this Column
My Numbers are in Column A and i Want to sort like column c.
Thanks in advanced.

Hi!

Try the Array Formula (use Ctrl+Shift+Enter to enter the formula) below in B2 and copy down:

=IFERROR(TEXT(1*MID(A2,1,SMALL(IFERROR(SEARCH(CHAR(ROW($65:$90)),A2),8^9),1)-1),"000")&
MID(A2,SMALL(IFERROR(SEARCH(CHAR(ROW($65:$90)),A2),8^9),1),20),A2)

	A	B	C	D	E	F	G
1	Data	Formula		Request Order		Form A-Z
2	1	001		1		001
3	5	005		1		001
4	7	007		1A		001A
5	9	009		1B		001B
6	2A	002A		1C		001C
7	2	002		2		002
8	6	006		2A		002A
9	1	001		2B		002B
10	1B	001B		3		003
11	1A	001A		4		004
12	2B	002B		5		005
13	4	004		6		006
14	3	003		7		007
15	1C	001C		8		008
16	8	008		9		009
17	10	010		10		010
18
***	******	********	**	*************	**	********	**

<tbody>
</tbody>

Markmzz