Is any function read strikethrough text in cell?

Hi,

Unfortunately Excel does not have it. however you can use VBA to generate a True/False.

Maybe something like this

Please Login or Register  to view this content.

However, you need a recalculation after the Strikethrough is changed.

I think you need a User Defined Function (UDF) in VBA to handle this.

For example, something like:

Please Login or Register  to view this content.

I must credit the majority of this solution to Damon Ostrander - I tweaked his code a little bit and then added a looping sub. This will remove the strikethrough, copy the cell, and then remove all commas since I was getting duplicates and just add spaces in between the countries. I am new to regex so if someone would like to tweak so that the commas are still there, that would be great.

Thank you.

Please Login or Register  to view this content.