Need to improve speed of Excel macro that searches for whole word matches

NoSparks · #18 02-19-2016, 05:24 AM

After reading and re-reading....

Maybe try adding this UDF.
Then in the main procedure, on the Split line, change RemovePunctuation to removeSpecial

Code:

Function removeSpecial(sInput As String) As String
    Dim sSpecialChars As String
    Dim i As Long
    sSpecialChars = "\/:*?™""®<>|.&@#(_+`©~);-+=^$!,'"     ' list of characters to deal with
    For i = 1 To Len(sSpecialChars)
        sInput = Replace$(sInput, Mid$(sSpecialChars, i, 1), " ")
    Next
    removeSpecial = sInput
End Function

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to speed up macro	AC PORTA VIA	Excel	3	10-30-2015 08:58 PM
Excel formula required to speed up process of creating species rarefaction curves. Ecology!	Tim_F	Excel	2	07-18-2014 04:56 AM
word and keyboard speed	ptz	Word	2	09-20-2012 06:37 AM
Help -can i improve this way of working?	lucky67	Office	1	01-26-2012 09:20 PM
Change how windows searches	cadams	Office	1	12-07-2010 10:01 AM