Parse cell value based on contents
Look at this example:
=if(iserror(YourFormula),"",YourFormula))
Regards,
Per
On 24 Sep., 04:42, Craig860
wrote:
In follow up to my previous question,
if
A1=Joe(abc)
a2=Sam(bdc)
a3=Sarah
to get the contents of the paranthesis in b1,b2 however b3 be blank, how
would would the formula go so I can avoid #VALUE! in b3.
ie:
b1=abc
b2=bdc
b3=
=MID(G2,FIND("(",G2)+1,(FIND(")",G2)-FIND("(",G2)-1)) will give me the
parenthisi value in it's own cell. But if there is no parenthisis, I get
#VALUE! which makes the spreadsheet look sloppy.
|