Sort Text & Number

[Irina]

Hello to everybody,

Need piece of advice. I have to sort some data by column that contains text & numbers:
week 1
week 2
week 3
...
week 10
week 11

and so on.

How it should be formatted?
Thanks a lot in advance,

Irina.

[Maistrye]

You might consider padding the week with 0's, ie. week 001, week 013, week 321, etc. Then it should sort normally.

Alternatively you could pad with spaces ie. week[space][space][space]1, week[space][space]13, week[space]321, etc.

You could also add a helper column that pulls out the week number.

Scott

[Irina]

You might consider padding the week with 0's, ie. week 001, week 013, week 321, etc. Then it should sort normally.

Alternatively you could pad with spaces ie. week[space][space][space]1, week[space][space]13, week[space]321, etc.

You could also add a helper column that pulls out the week number.

Scott

Thank you. I just wanted to use the way MS Excel suggests to use in the "Help". Something like "Format it as custom", but all my efforts had the same "wrong" result.

[oldchippy]

You could number your weeks, say 1, 2, 3, 4, etc., then custom format the cell to

"Week "###

[Irina]

You could number your weeks, say 1, 2, 3, 4, etc., then custom format the cell to

"Week "###

Works perfectly, thanks.