Search text field for word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Could someone help me with a formula to find the word Contractor in column AB
and have that word appear in the free column AC? This would be for a very
large worksheet so I'd drag the formula down. AB has text in it.
TIA,
GerryK
 
=IF(ISNUMBER(SEARCH("contractor",AB2)),"Contractor","")



--


Regards,


Peo Sjoblom
 
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

Search two columns in list for first and last name and return Id 4
Return Top Ranks For Certain Categories in Column 7
copy formula - keep cell same but increment sheet numbers 5
Help creating a formula that repeats text & increments an integer 3
CONCATENATE I have two text strings in cells but it wont work 1
Finding Corresponding Cell Value 2
Find exact value using LOOKUP 7
Populating Cells with Table Data 1

Back
Top