Computed value returning#VALUE
Try this
=TRIM(MID(SUBSTITUTE(U3,"",REPT("",255),2),FIND("" ,U3)+1,255))
You had introduced commas and extra spaces in between "".
--
Russell Dawson
Excel Student
Please hit "Yes" if this post was helpful.
"Kennedy" wrote:
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.
|