Say the names are in A1 thru A1000. In B1 enter:
=TRIM(A1) and copy down

You can then copy column B and PasteSpecialValue back onto column A if you
like.
--
Gary''s Student - gsnu200768


"Supe" wrote:

I recieved a list that has several hundred names that I was going to do a
VLOOKUP on to put in some data from another spreadsheet. The list I received
has one space at the beginning of each name so the VLOOKUP won't work. How
can I remove this space without going into every single cell and deleting?