Hi Don,
Thanks for your effort.
On Thu, Dec 29, 2011 at 5:53 PM, Excel_Lover wrote:
> Why?
>
>
> On Thu, Dec 29, 2011 at 5:48 PM, dguillett1 wrote:
>
>> That’s good. I went back and tested mine. NOT good.
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>> *From:* Kris
>>
Why?
On Thu, Dec 29, 2011 at 5:48 PM, dguillett1 wrote:
> That’s good. I went back and tested mine. NOT good.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Kris
> *Sent:* Thursday, December 29, 2011 8:06 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-
That’s good. I went back and tested mine. NOT good.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Kris
Sent: Thursday, December 29, 2011 8:06 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: To Extract a text with Conditions
Hi,
Try this UDF.
Function FINALDEST
Works Great, Thank you very much.
On Thu, Dec 29, 2011 at 5:06 PM, Kris wrote:
> Hi,
>
> Try this UDF.
>
> Function FINALDEST(ByRef v) As String
>
> Dim x, i As Long
>
> If TypeOf v Is Range Then v = v.Value2
>
> x = Split(v, "-")
>
> With CreateObject("scripting.dictionary")
>