Hi I have two columns Say A & B.----------around 40000 names in both the columns I need to trim those two columns.. i need VBA Code . Note --inbetween thr are blanks also