Dear All,
I am using a formula to extract the word from phrase which is as below
=REPT("Relay",--ISNUMBER(SEARCH("Relay",$T64)*SEARCH("replaced",$T64)))
The formula is applied on AA:BB colums and on Excel 2007.
The formula works awesomely well. But file is getting havy and slower. I need a...