=FIND function to look for bold or italic text

[ferrigeu]

hi guys
I wonder if anyone has come up with a non-VBA solution to find and identify text in cells that are e.g. in BOLD or Italic font?

A1 = THIS IS A test of the content
A2 = 19 (i.e. it starts at the 19th character for Italic)
A3 = 6 (i.e. it starts at the 6th character for BOLD)

doable?
VBA is out as I can not use it at my place of work!

thank you

 

[Joe4]

I am pretty sure that Excel formulas can only work on values, not formatting.
So I afraid that without VBA, you are going to be out of luck.

 

[ferrigeu]

therefore, I am attached to another object by an inclined plane, wrapped helically around an axis... LOL