Microsoft Office Forums - View Single Post - [Solved] Sorting method

Thread: [Solved] Sorting method

View Single Post

Old

10-21-2016, 05:07 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

One quick and easy way...

Say your list is in A2 and down

In B2 use the formula =SUBSTITUTE(A2,"C","")+0

Now sort by column B smallest to largest

Reply With Quote