Help can- resolve an excel problem

[elo0707]

Hello.  I have the following formula in the yellow highlighted area. IF(FIND("*",E40)=1,MID(E40,3,4),C41)   and the formula is not working for whatever reason.  can't seem to figure it out.    What i want to do is for the formula to find * within the tezt in Column E, and when it does extract the characters i want in this case "B10", and appear B10 to the yellow highlighted area in column C.      there is like 3 spaces before the numbers in column E (purple highlightighted data), is that the problem.   HOw do you fix formula so that it works without giving me an error?

[#2]

@elo0707 Try this:

=IF(ISERROR(FIND("*",E40)),C41,MID(E40,3,4))

[#3]

@Riny_van_Eekelen 

Thank you so much!  it worked like a charm.