View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Munkeeric Munkeeric is offline
external usenet poster
 
Posts: 3
Default How do I remove spaces at the beginning of cells?

I have a column of names I need to sort. Unfortunately, some of the cells
have 1 or 2 leading spaces, which cause the zero-leading spaces to be sorted,
then the one-leading space, then two-leading space. And since there are over
3000 names to be sorted, doing them by hand is problematic.