Maybe inserting a helper column of cells with formulas like:

=trim(a1)
and drag down.
Then copy|paste special|values over the original range and delete the helper
column.

=trim() will remove leading/trailing/repeated embedded spaces, too

If you want to cheat (this is usually a bad idea!):

=VLOOKUP(A6,$N$4:$O$348,2)
becomes
=VLOOKUP(trim(A6),$N$4:$O$348,2)

But it's always better to fix the data.

marksuza wrote:

Yes Dave, I just checked and in one of them I have an extra space at the
end. Is there a formula to get this space out in all the rows. Thanks
for the help once again.

Regards,

Marcos

--
marksuza
------------------------------------------------------------------------
marksuza's Profile: http://www.excelforum.com/member.php...fo&userid=2659
View this thread: http://www.excelforum.com/showthread...hreadid=495506

--

Dave Peterson