IF ignoring special characters

=IF(LEFT(B2,5)="Slide","",IF(AND(ISNUMBER(B2),B2>0),"",IF(B2="a name","","Action")))

                                                                         
Hi, if B2 contains character  -------

i would like to ignore, leave blank, i would implicity state this but the amount of dashes varies e.g

-------
-----------------

and on some lines are stacked on tope of each other

Thanks
Seamus2626Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Or maybe

=IF(or(LEFT(B2,5)="Slide",LEFT(B2,5)="-----",LEFT(B2,5)="====="),"",IF(AND(ISNUMBER(B2),B2>0),"",IF(B2="a name","","Action")))
0
 
Saqib Husain, SyedEngineerCommented:
=IF(or(LEFT(B2,5)="Slide",LEFT(B2,5)="-----"),"",IF(AND(ISNUMBER(B2),B2>0),"",IF(B2="a name","","Action")))
0
 
Seamus2626Author Commented:
Hi ssaqibh,

that did not ignore

===================

thanks
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
barry houdiniCommented:
Perhaps try

=IF(OR(LEFT(B2,5)="Slide",COUNTIF(B2,"*--*")),"",IF(AND(ISNUMBER(B2),B2>0),"",IF(B2="a name","","Action")))

regards, barry
0
 
Saqib Husain, SyedEngineerCommented:
replace the ----- with =====
0
 
Seamus2626Author Commented:
Barry, your formula dramatically increased what i was expecting back. ssaqibh bought back what i was expecting

many thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.