'How to search a column of names and make a decision based on whether the name has special characters on the end
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.
Solution 1:[1]
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"))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Scott Craner |