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.

With the incorrect data in A1, in B1 enter =TRIM(A1)
Copy down for all rows, then copy the range, and paste special values in
column A

"ferdy" wrote:

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.

If your string is in cell A1, and reads " My String" (Without quotes!)

Then to put a trimmed version in another cell use the formula

=Trim(A1)

in the target cell


HTH

Neil
www.nwarwick.co.uk

"ferdy" wrote:

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.

Kassie & Neil
Thank you for your advice - it is so simple, but it has saved me hours and
hours of work.
I am very grateful.

"Neil" wrote:

If your string is in cell A1, and reads " My String" (Without quotes!)

Then to put a trimmed version in another cell use the formula

=Trim(A1)

in the target cell


HTH

Neil
www.nwarwick.co.uk

"ferdy" wrote:

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.

Glad to have been of help. Thanks for the response

"ferdy" wrote:

Kassie & Neil
Thank you for your advice - it is so simple, but it has saved me hours and
hours of work.
I am very grateful.

"Neil" wrote:

If your string is in cell A1, and reads " My String" (Without quotes!)

Then to put a trimmed version in another cell use the formula

=Trim(A1)

in the target cell


HTH

Neil
www.nwarwick.co.uk

"ferdy" wrote:

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.