Re: $$Excel-Macros$$ Re: To Extract a text with Conditions

2011-12-29 Thread Excel_Lover
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 >>

Re: $$Excel-Macros$$ Re: To Extract a text with Conditions

2011-12-29 Thread Excel_Lover
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-

Re: $$Excel-Macros$$ Re: To Extract a text with Conditions

2011-12-29 Thread dguillett1
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

Re: $$Excel-Macros$$ Re: To Extract a text with Conditions

2011-12-29 Thread Excel_Lover
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") >