removing space from the start of a string

  • Thread starter Thread starter n
  • Start date Start date
N

n

hi all;

i have a list of a million names to sort. some names have a space at
the beginning and thus appear at the top (A->Z sort) irrespective of
the actual first letter.

how do i check for and remove such spaces?

eg " vista" should be replaced by "vista" and sorted accordingly.

Thanks and regards
 
Suppose your names are in column A: In a helper column type =TRIM(A1). Copy
and PasteSpecial Values to get rid of the formulas.
JM
 
Suppose your names are in column A: In a helper column type =TRIM(A1). Copy
and PasteSpecial Values to get rid of the formulas.
JM










- Show quoted text -

Thanks! i used a bit different approach. copied the cell withe
formula, =trim(A1) and then selected the same column and paste
special formula! This worked the formula on all the million names.
then i copy and paste special the values.

Hope this helps someone facing a similar problem.
 
Back
Top