Search for sting in cell

I want to look at a cell and determine if a string is present and if so create an entry.
Cell possibilities:
Jim Jones***
Sally Smith*
Bob Burns**
Allen Barnett

Desired results:
If the cell has one asterisk enter "Fees".
If the cell has two asterisks enter "Wavier".
If the cell has three asterisks enter "N/A"
If the cell has no asterisks enter "Pay Fees and Sign Wavier".

Thanks,
Marvin
mabarnes11Asked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
=len(a1)-len(substitute(a1,"*",""))

will give you the number of asterisks in A1

=choose(len(a1)-len(substitute(a1,"*",""))+1,"Pay Fees and Sign Wavier","Fees","Wavier","N/A")
0
 
mabarnes11Author Commented:
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.