if statement/formula by font, is it possible

[smakatura]

Good morning.

I am expecting the answer to this question to be no based my current knowledge but someone her may have better advise.

I want to do an concatenate with an if. something that looks at a2 to see if the font is "strike thorough" and if it is then don't include in the concatenate, if it is not "strike through", include in the concatenate.

I wrote a formula below with parts of if statement are not proper wording but I hope it gives a better idea of what Is in my head

=if(format(a2)<>strikethougth, concatenate(a2,b2,c2), concatenate(b2,c2)

 

[shg]

It would require either VBA or an XL4 macro function(GET.CELL(23, ...)). Either way, it would need to be a macro-enabled workbook.

 

[smakatura]

thank you, I thought that might be the case

 

[shg]

You're welcome.