I have a computed value
=TRIM(MID(SUBSTITUTE(U3,",",REPT(" ",255),2),FIND(",",U3)+1,255))
that pulls the date out of a string of text. In this case, the date is
returned because their is data in U3. However, when I have columns that do
not have data, it returns a #VALUE. Is there a way to get around this. The
column being referenced is also a computed value, so I am wondering if that
is the case.