how about

for each c in range("a2:a22")
c.value=ltrim(c)
next c

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Supe" wrote in message
...
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?