I am trying to write a function where if the cell contains a certain string
to return the data upto that string else return the entire string. Here is
what I have so far:

=IF(SEARCH("(oc:",B1,1)0,LEFT(B1,SEARCH("(oc",B1, 1)-2),B1)

This works if the string exists in the cell but if it doesn't, it returns
#VALUE. Where am I going wrong? TIA
--
Tony

Try this...

=IF(ISERROR(SEARCH("(oc:",B1,1)),B1,LEFT*(B1,SEARC H("(oc",B1,1)-2))

HTH,
OJ

Thanks OJ. That did the trick

Tony

"OJ" wrote:

Try this...

=IF(ISERROR(SEARCH("(oc:",B1,1)),B1,LEFTÂ*(B1,SEAR CH("(oc",B1,1)-2))

HTH,
OJ