How to search a column of names and make a decision based on whether the name has special characters-CodePudding

Must be able to identify special characters on end, specifically *,**,***, , .
Must make a decision on whether there is one, two, three asterisks and one or two plus symbols. For example:

Alston*
Jordon**
Baker***
Haskel 
Mike  
Tom

e.g. * might mean use cell X15, ** might mean use cel X16, etc.

Would like to use formulas.

CodePudding user response：

Use:

=IF(ISNUMBER(FIND("*",A1)),"Cell has "&LEN(A1)-LEN(SUBSTITUTE(A1,"*",""))&" *(s)",IF(ISNUMBER(FIND(" ",A1)),"Cell has "&LEN(A1)-LEN(SUBSTITUTE(A1," ",""))&"  (s)","No Special characters"))