Okay, I've asked a couple of questions and maybe I should be giving the whole
picture.

I pull data from 5 different sources and the only common data is name and
alias. 3 of these sources give me data with that stupid return character
after SOME of the fields but not all. I need to remove that character. The
clean function works but only if there is a non-readable character. If not I
get the #Value in the cell.

One of the other sources has names but not necessarily alias' and not
necessarily the name spelled correctly. (That field is user entered and I
can't get around that).

I need to combine all the data then check the names against the last source,
but not every entry may have a name in the last source so those need to be
checked against the Outlook global address list and return their alias.

I thought this would be easy. I can call the Outlook application but I
can't figure out how to look up a name and return the alias. Am I being too
optomistic about this being simple?