Like Operator

[Chance1234]

Hullo and glad tis day is friday !!!!

im having a wee bit of a problem,

i have two lists of names

which i am comparing to each other via an array and it all works fine BAR where there are slight differences in the name, for example in one list it might be

Allen, Mark

and in another it could be

Allen,Mark (j)

the differeces allways occur after the name

this is the code i have

NB.

Ctre
Ctrm our counters

Do Until CtrE = UBound(aRrEdaT)

loOkfOrmE = aRrEdaT(CtrE, 5)

Do Until CtrM = UBound(emaildata)

If emaildata(CtrM, 1) Like "" & loOkfOrmE & "*" Then
aRrEdaT(CtrE, 3) = emaildata(CtrM, 2) & "#" & emaildata(CtrM, 2)
End If

CtrM = CtrM + 1
Loop
CtrM = 2

CtrE = CtrE + 1


Loop

but it doesnt seem to be working, any ideas?

 

[Chance1234]

btw i solved it


with Instr function which worked a treat for anyone with similiar probs