sort column A with "strike-through" values come first

  • Thread starter Thread starter William Poh Ben
  • Start date Start date
W

William Poh Ben

Hi EXCEL expert,

I have this problem I have been facing for a long time at work not abl
to sort the data in column A in order to have the cells containing th
"strike-through" values in column A appear first, follow by the value
without the "strike-through".

My column A consists of Part Numbers and the strike-through applies t
all letters/numbers in the cell, and not only certain letters/numbers.

Appreciate very much if someone can help me with a VBA code to solv
this problem

Thanks in advance
 
can you use a helper column?

You could create a UDF

Public Function IsStrikeThrough(rng As Range)
Application.Volatile
IsStrikeThrough = rng.Font.Strikethrough
End Function

Use this in an adjacent column and use that as the first sort key.
 
Back
Top