Use the TRIM function. E.g.,

=TRIM(A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"SL" wrote in message
...
Ingrid,

Thank you for the tip. It did work. One other question. What
is the
function to clear all spaces after the name? Example:
JamesSarah# (where #
equals space)

SL

"Ingrid" wrote:


Try this:

Add to both spreadsheet a colomn and combine the first and
last name
together (=A1&B1). If you need more information just add them
to your
combination. You can then use your VLOOKUP again. Works like a
charm.


--
Ingrid
------------------------------------------------------------------------
Ingrid's Profile:
http://www.excelforum.com/member.php...o&userid=27386
View this thread:
http://www.excelforum.com/showthread...hreadid=468318