Watch your apostrophes:

=IF(NOT(ISERROR(SEARCH("ACS",'Worksheet1'!a1))),'W orksheet1'!a1,"")

And sometimes just using =isnumber() makes the formula easier to read:

=IF(ISnumber(SEARCH("ACS",'Worksheet1'!a1)),'Works heet1'!a1,"")




Dave F wrote:

=IF(NOT(ISERROR(SEARCH("ACS",'Worksheet1!a1'))),'W orksheet1!a1',"") ???

Dave
--
Brevity is the soul of wit.

"Shelly" wrote:

Hello,

I need to determine if a cell in one worksheet has a specific string of
characters, and if yes, copy the entire cell to a second worksheet.

So,

If 'Worksheet1!a1' contains the string "ACS", copy the content of
'Worksheet1!a1' to 'Worksheet2!a1'

I've tried several things I've found on this BB, but not luck so far.

THANKS!

--

Dave Peterson