View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Supe Supe is offline
external usenet poster
 
Posts: 59
Default Remove space at beginning of each name

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?