Hi again,
If I input this list to be processed by the macro:
abnormal termination
abnormal
abort
about
absolute
absolute address
absolute code
accent
access
access address
access mode
access control
access time
address
The case with "address" will be handled as follows:
address - absolute addre
what in case of address
which one it should pic
absolute address access address
On Fri, May 13, 2011 at 8:42 PM, Ivaylo wrote:
> Hi Ashish,
>
> Thank you very much for your efforts!
>
> Your macro is just what I needed.
>
> However, it seems that it doesn't handle the exceptions:
>
>
Hi Ashish,
Thank you very much for your efforts!
Your macro is just what I needed.
However, it seems that it doesn't handle the exceptions:
===
How to handle exceptions:
If the consituent word doesn't have its own headword in the list,
then
the missing
try this code
Sub tests()
Dim i As Long
Dim z As String
For i = 1 To Sheets(1).Range("a65356").End(xlUp).Row
If InStr(1, Application.WorksheetFunction.Trim(Cells(i, 1)), " ") > 0 Then
Cells(i, 2) =
Application.WorksheetFunction.Substitute(Application.WorksheetFunction.Trim(Cells(i,
1)), " "
Hi to all VBA gurus,
I need help with an Excel macro which can do the following:
I have a long list of dictionary headwords in column A (sorted
alphabetically), something like this:
abnormal termination
abnormal
abort
about
absolute
absolute address
absolute code
accent
access
access address
acc
