On Mon, 25 Jun 2007 19:45:00 -0700, Eric
wrote:

Under cell A1, which contains a link to file C:\ABC\[Sample.xls]Sheet1!A1.
In cell B1, I would like to detect whether cell A1 contains "ABC" characters
inside this path, if yes, then return String "ABC", else nothing "".

Does anyone have any suggestions?
Thank in advance for any suggestions
Eric


=IF(ISNUMBER(FIND("ABC",A1)),"ABC","")


--ron