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

[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

 

[Tom Ogilvy]

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.