Forum Discussion
elo0707
Feb 02, 2023Copper Contributor
Help can- resolve an excel problem
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...
Riny_van_Eekelen
Feb 02, 2023Platinum Contributor
elo0707 Try this:
=IF(ISERROR(FIND("*",E40)),C41,MID(E40,3,4))
- elo0707Feb 02, 2023Copper Contributor