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)
.comparemode = 1
For i = 0 To UBound(x)
If Len(x(i)) Then
Hi Don,
Thanks for your effort.
On Thu, Dec 29, 2011 at 5:53 PM, Excel_Lover idforex...@gmail.com wrote:
Why?
On Thu, Dec 29, 2011 at 5:48 PM, dguillett1 dguille...@gmail.com wrote:
That’s good. I went back and tested mine. NOT good.
Don Guillett
SalesAid Software
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
Works Great, Thank you very much.
On Thu, Dec 29, 2011 at 5:06 PM, Kris krishnak...@gmail.com 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
Why?
On Thu, Dec 29, 2011 at 5:48 PM, dguillett1 dguille...@gmail.com wrote:
That’s good. I went back and tested mine. NOT good.
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Kris krishnak...@gmail.com
*Sent:* Thursday, December 29, 2011 8:06 AM
*To:*