Trim whitespace from end of last word in all rows in column A?

[Westin]

Hello,

I've made a mistake in "some" of the rows in Column A of my spreadsheet.

Some of the contents (words) in Column A have an extra blank whitespace at the end of them. But I need them to end with the last letter in that field.

Now, if it was just a matter of a couple dozen entries, I'd fix it by hand, but it's actually a matter of about 14,560 rows of data, some with the extra whitespace at the end of the last word in some rows in column A and some without.

Is there an easy way for me to strip/trim off the extra blank whitespace at the end of the last word in each row in column A?

If so could you please explain how to accomplish this. I'm not fluent in Excel, so simplistic instructions would really help me to understand your instructions on how to accomplish this.

Thank you for your time, it is appreciated.

[shg]

Welcome to the forum.

See Help for the TRIM function.

[Westin]

I looked at that, what I can't figure out about that is that it wants me to enter the text, but each row has totally individual text in it so no two rows will have the same last word. This is where it leaves me baffled as to what I have to enter for the text since each last word is different in each row of column A.

[shg]

In a separate column, enter =trim(w1) and copy down (assuming W is the column of interest).

Then copy those results, and paste as values over the original data.

[Jocote46]

=LEFT((A1),LEN(TRIM(A1))-1)

this formula is used to copy contents of a cell but getting rid of the last character. (-1) is the number of characters at the end that need to be eliminated.

Try this, I used this before. good luck.