"Bob Phillips" wrote in message
...
1. Check ToolsOptionsView and make sure that Formulas is not checked.

Formulas not checked. Problem was cell formatted as Text when data imported
from .txt file. Kept format as General and it worked
2. Try =VLOOKUP(A2,NAMES,2,False) in case they are not ordered.

Have tried both ways. Neither worked. Suspect VLOOKUP looks at actual
content of cell rather than result of formula, hence "Joe Bloggs" not
contained in "=CONCATENATE(A3," ",A2)
--
Bob JONES

Give me ambiguity or give me something else