Check syntax Full stop then space

[richiwatts]

Hi,

I am not very good with syntax but I need to find cells that have a full stop then a space in one cell but not in the other.

I get an error with this

[Target] Like "*" & Chr(46)Chr(32) & "*" AND [Source] Not Like "*" & Chr(46)Chr(32) & "*

 

[PHV]

Replace this:
& Chr(46)Chr(32)
with this (2 times)
& Chr(46) & Chr(32)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

Anyway, why not simply this ?

[Target] Like "*. *" AND [Source] Not Like "*. *"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[richiwatts]

Perfect thanks