Hello,
I am trying to remove an extra space at the end of a text string in my database. I have searched the message boards and found that "TRIM" would be useful. I have tried this formula but it doesn't work.
I am making a new column (column B) next to my original data and using =TRIM(A1) as an excel formula. Then when I copy column B and paste values of this column, the extra space remains.
The extra space is always at the end of the text string. Is there another way to write some VBA code to remove the last character of the value of the cell if it is not a letter a-z?
I am trying to remove an extra space at the end of a text string in my database. I have searched the message boards and found that "TRIM" would be useful. I have tried this formula but it doesn't work.
I am making a new column (column B) next to my original data and using =TRIM(A1) as an excel formula. Then when I copy column B and paste values of this column, the extra space remains.
The extra space is always at the end of the text string. Is there another way to write some VBA code to remove the last character of the value of the cell if it is not a letter a-z?