Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find a particular word? | Excel Worksheet Functions | |||
Script to find the word END | Excel Programming | |||
Find last word in cell | Excel Programming | |||
Find word and copy | Excel Programming | |||
Find Whole Word Only | Excel Programming |