Computed value returning#VALUE
Thanks to both of you. Both worked well. Going to use the one that T. Valko
submitted.
Again...THANK YOU both...geniuses!
"T. Valko" wrote:
Try this...
=IF(U3="","",TRIM(MID(SUBSTITUTE(U3,",",REPT("
",255),2),FIND(",",U3)+1,255)))
--
Biff
Microsoft Excel MVP
"Kennedy" wrote in message
...
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.
.
|