In SheetA
-----
Put in D1: =IF(A1="","",IF(ISNUMBER(FIND("EMC",A1)),ROW(),"") )

Just some clarifications:

I presumed you wanted the search for "EMC" to be case sensitive. That's why
FIND was used in the above formula. If however, you need it to be
case-insensitive, just replace FIND with SEARCH in the formula.

And instead of hardcoding the target phrase "EMC" into the formula, we could
point the formula at an adjacent cell, say: E1, and enter the target phrase
in E1. This "softcoding" is useful if we have to do the same thing over for
other target phrases.

Then just put instead in D1:
=IF(A1="","",IF(ISNUMBER(FIND($E$1,A1)),ROW(),""))
and copy D1 down as before
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----