Re: Search text field for word
- From: "Peo Sjoblom" <terre08@xxxxxxxx>
- Date: Fri, 14 Sep 2007 07:42:13 -0700
=IF(ISNUMBER(SEARCH("contractor",AB2)),"Contractor","")
--
Regards,
Peo Sjoblom
"GerryK" <GerryK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1C9A615A-9E86-4509-9488-282036887678@xxxxxxxxxxxxxxxx
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 work*** so I'd drag the formula down. AB has text in it.
TIA,
GerryK
.
- Prev by Date: Re: Count Occurrences In A Column, Then Display In A Table
- Next by Date: Re: Search text field for word
- Previous by thread: Re: Import data from Excel into Word document fomat
- Next by thread: Re: Search text field for word
- Index(es):
