I am struggling with Trim.  Please can somebody advise me step by step what I
should do to remove an unwanted space from text entries.  I have a column
which is approx 2000 rows long, and quite a few of the cells have a space
before the text (ie on the left hand side of the text).  I am fairly sure the
work sheet contains imported data , as it is an address data base with quite
a few columns, and all the columns suffer from this problem (they are also
out of sequence across the columns in some cases but I can fix those
individually).  I dont know which software the data was was exported from as
I was given the worsheet to cleanse.  I think I should perhaps use Clean
first to see if they are actually spaces but I am not sure how to do this
either.  Any help very gratefully received please.