Need help on Trimming

vijaydm

New member
Joined
Jun 9, 2012
Messages
6
Reaction score
0
Points
0
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
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,522
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Trim in what way? You want to remove the spaces around them?

If so, it would be much faster to extend =TRIM(A1) down your 40,000 rows, copy the data and paste it as values...
 

vijaydm

New member
Joined
Jun 9, 2012
Messages
6
Reaction score
0
Points
0
Thanks for your reply.. i tried before it self. but taking for more to run..
 

vijaydm

New member
Joined
Jun 9, 2012
Messages
6
Reaction score
0
Points
0
if i use = trim(cell) & autofill to last row.. Its taking more time to run..thanks
 
Top