Prev: Forumla List
Next: Excel 2007 - freeze multiple panes?
From: T. Valko on 23 Mar 2010 14:41
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Kennedy" <Kennedy(a)discussions.microsoft.com> wrote in message
news:08EA4C1E-36FF-4942-8945-1D88DFC8572B(a)microsoft.com...
> 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" <Kennedy(a)discussions.microsoft.com> wrote in message
>> news:9F211580-0981-48E5-B282-497389B77F5D(a)microsoft.com...
>> >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.
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: Forumla List
Next: Excel 2007 - freeze multiple panes?