Solved

# Search for sting in cell

Posted on 2014-01-21
202 Views
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
0
Question by:mabarnes11

LVL 43

Accepted Solution

Saqib Husain, Syed earned 500 total points
=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

Author Closing Comment

Thanks!!!
0

## Featured Post

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.