Sort by Page # & Sequence

I'd Like to format a column with Catalog Page and Item Sequence number that sorts both before and after the separator instead of having two columns. I tried 117.12, 117.13 Etc. where 117 is the p...

excel

HansVogelaar
May 09, 2021
UncleFiat

An easy solution would be to pad all item numbers to 3 digits:

HHCSMP8.8 117.100

HHCSMF8.8 117.001

HHCSMF8.8 117.101

HHCSMF8.8 117.011

HHCSMF8.8 117.013

The values will then be sorted the way you want by Excel.

Another would be to record the page number and item number in separate columns.

If you don't want to do either, you could use helper columns:

In C2, enter the formula =INT(B2)

In D2, enter the formula =--MID(B2,FIND(".",B2)+1,3)

Fill down.

You can then sort on columns C and 😧