Formula to ignore if criteria not met for extracting certain text

[kidiowa]

Me again, and another question. I figured out a part of the problem, I'm able to extract the initials after "By:", but I get the #Value! error when cells don't meet the criteria. Is there a nesting function (IF function?) that I can put into the below formula that says to leave the cell blank if "By:" not found?


=MID(C3,FIND("By:",C3)+4,6)

 

[Dhamo]

=IFERROR(MID(C3,FIND("By:",C3)+4,6),"")

 

[Luke M]

Quick side note: If you don't need to be case-sensitive, I'd use SEARCH instead of FIND. Less chance of accidentally missing something is someone types "by:" instead of "By:"

 

[kidiowa]

Dhamo and Luke, you guys are wicked awesome!