find word
 

Hi all,

i have a worksheet containing rows of jobs and their respective
descriptions. In some instances, where the job description says 'Pump
Replacement' I would like to insert the words 'high prioirity' in an
additional cell at the end of the row. Sometimes there are numbers or other
words before or after the job description so I need to search fot the term
'pump description' as opposed to using instr or LEFT functions.

Does anybody know how to do this?

Regards

find word
 

In a cell formula:
=IF(ISERROR(FIND("Pump Replacement",A1)),"","High Priority")

In VB
If InStr(1,Range("A1"),"Pump Replacement") 0 Then
'Found
Else
'Not Found
End If

Charles


Ron wrote:
Hi all,

i have a worksheet containing rows of jobs and their respective
descriptions. In some instances, where the job description says 'Pump
Replacement' I would like to insert the words 'high prioirity' in an
additional cell at the end of the row. Sometimes there are numbers or other
words before or after the job description so I need to search fot the term
'pump description' as opposed to using instr or LEFT functions.

Does anybody know how to do this?

Regards

find word
 

GREAT! thank you die!

"Die_Another_Day" wrote:

In a cell formula:
=IF(ISERROR(FIND("Pump Replacement",A1)),"","High Priority")

In VB
If InStr(1,Range("A1"),"Pump Replacement") 0 Then
'Found
Else
'Not Found
End If

Charles


Ron wrote:
Hi all,

i have a worksheet containing rows of jobs and their respective
descriptions. In some instances, where the job description says 'Pump
Replacement' I would like to insert the words 'high prioirity' in an
additional cell at the end of the row. Sometimes there are numbers or other
words before or after the job description so I need to search fot the term
'pump description' as opposed to using instr or LEFT functions.

Does anybody know how to do this?

Regards