Thread: Trim function
View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

They may not be spaces. Take a look at CLEAN in the XL
help guide and give it a try.

HTH
Jason
Atlanta, GA

-----Original Message-----
On a column of imported text there are unwanted spaces to

the left of the
text. I tried to get rid of them by inserting a column

and writing a TRIM
function but the spaces remained - I've never seen that

happen before. Does
anyone have an idea why that should happen? I'm tearing

my hair out. Any
ideas would be gratefully received. Thanks.
.