search cell for certain value

  • Thread starter Thread starter cparsons
  • Start date Start date
C

cparsons

I got this to work but it is only looking at the first position.
still need something that will check the entire cell.

=IF(LEFT(A1,1)="%","Contractor","")

Thanks
 
Hi,
I'm not sure if this is the most efficient, but try:
=IF(ISERROR(FIND("%",A1)),"","Contractor")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find function returns the #VALUE! error value 2
Search for string of characters in a cell 3
Need formulas to return multiple data matches 1
Multiple If/Then formulas in one cell 4
Splitting text and numbers from a cell 6
Conditional formatting in Excel 2010 2
Acending descending filter screwed my spreadsheet... 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top