I have a worksheet with name info from 2 databases. I'm trying to match
names in different columns that have different formats. One has LN, FN,
Initial format, presented in 1 column (Column B), the other has LN,FN
with info in 2 columns (Cols. H:I), all names sorted alpha ascending.


Due to the queries involved (PeopleSoft & Employease DB's), I do not
have a matching determinate like SSN.

I poked around using MS Help - that was an exercise in frustration, and
even tried to cobble together a funtion using VLOOKUP and ISNA was
futile because of the name length mismatch. The shortest employee name
is 4 characters.

LEN only returns the actual length of the text string, and I can't
figure out how to solve this. Can you help with this problem? Any help
is sincerely appreciated.

Mark
Boston


--
LTUser54
------------------------------------------------------------------------
LTUser54's Profile: http://www.excelforum.com/member.php...o&userid=33459
View this thread: http://www.excelforum.com/showthread...hreadid=544339