ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Check font strikethrough (https://www.excelbanter.com/excel-programming/315623-check-font-strikethrough.html)

Ben

Check font strikethrough
 
Hi,

How to I check whether there is any striketrough on the text in one cell
with another text in another cell example:
column: a b

text text

where the two text are strikethrough?

thank.

regards,
Ben

Tom Ogilvy

Check font strikethrough
 
It is not clear what you are trying to do. You can check each character in
one cell and see if any are marked as strikethrough. But how does that
relate to the second cell. Are you only interested in text in the first
cell that matches text in the second cell, so you would be checking a subset
of characters in the first cell?

If that is the case, will all the text in the second cell be found in the
first cell? Will it be exact. For example if the second cell contained
The dog is big

Will the phrase "The dog is big" be found as a phase in the first cell or
might there only be the words "dog" and "big" somewhere in the first cell,
and not necessarily in any order.

--
Regards,
Tom Ogilvy

"Ben" wrote in message
...
Hi,

How to I check whether there is any striketrough on the text in one cell
with another text in another cell example:
column: a b

text text

where the two text are strikethrough?

thank.

regards,
Ben




Ben

Check font strikethrough
 


"Ben" wrote:

Hi,

How to I check whether there is any striketrough on the text in one cell
with another text in another cell example:
column: a b

text text

where the two text are strikethrough?

thank.

regards,
Ben



All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com