Spacing

H

Hasan

i have about 300 fields in 1 column and there is a space
before most words that doesn't allow me to sort the
column properly as the words with spaces before them are
shown first and then it starts with the alphabets A-Z. Is
there a way to get rid of the spaces infron of the words
collectivelly rather then wasting time to do it 1 by 1.
Thankyou
Hasan
 
A

Anne Troy

=trim(a1) gets rid of spaces before and after the contents of a1.
If there are otherwise no spaces in your cells, just do a find/replace. Find
a space and replace with nothing. Replace all.
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Web: www.VBAExpress.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
H

Hasan

Thanks alot mate it works a treat.
-----Original Message-----
=trim(a1) gets rid of spaces before and after the contents of a1.
If there are otherwise no spaces in your cells, just do a find/replace. Find
a space and replace with nothing. Replace all.
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Web: www.VBAExpress.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->



.
Click to expand...
 
Top