Custom format help

[qazqaz]

Hello

I have a Column get the SQL data on the way

Step 7,8,9,10,11,13,14

When i sort it comes like this 10, 11, 13, 14, 7, 8, 9

So Using macro or any other way i want to add
Step 01, 02, 03, 07, 08 and if its more than two digti leave as it is step 10, 11,13

Then when i sort i will get Step 07, 08, 09, 10

ANy tips

[JBeaucaire]

Put this in B2 and copy down:

=IF(LEN(SUBSTITUTE(A2,"Step ",""))>1, A2, "Step " & TEXT(SUBSTITUTE(A2,"Step ",""), "00"))


Now sort by this column.

[qazqaz]

I am not sure where to put and how to put this formula. I am new to excel format. Can you help me? I tried in

Excel - Format Menu and tools menu also. When i type this formula it display error.

[qazqaz]

I got it now. thanks for your help

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.