I have imported two similar lists of names into a worksheet, 1 from an excel
worksheet and 1 from an access data base when I ask a cell to search the
first list for a name from the second list it does not find it because the
list imported from access has spaces added behind the names so although the
name appears to look the same in the cell excel ignores it in a search. If I
type the same name into a diffrent cell and use the same formula it is
located. why are the spaces added on import when they are not in the original
data? how can I stop them being added or how can I search an array forcing
excel to ignore the spaces?