=FIND function to look for bold or italic text

ferrigeu

New Member
Joined
Jun 14, 2017
Messages
15
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,771
Office Version
365
Platform
Windows
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

New Member
Joined
Jun 14, 2017
Messages
15
therefore, I am attached to another object by an inclined plane, wrapped helically around an axis... LOL
 

Forum statistics

Threads
1,085,352
Messages
5,383,114
Members
401,815
Latest member
nube78

Some videos you may like

This Week's Hot Topics

Top