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

Viewed 40

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.

1 Answers

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"))

enter image description here

Related