Deleting Space at End of Cell.

[tanahteck]

Hi All, reading thru the various thread cant really find the solution to my problem, my columns A has 2,000 rows, each rolls have a Blank Space after the text [Eg Call A1 (XXXX ), A2(YYYY ), there is a space after the XXX,YYYY), how do I delete the space for all the 2000 rows? Appreciate your kind assistance.

 

[Tazguy37]

Welcome to MrExcel Board!

Here's one way:

Select the column (or cells, if it's not the whole column).
Go to Data, Text to Columns.
Choose Delimited, and click Next.
Choose Space, and click Finish.

That should do it. Hope that helps! Post back if you have any more problems.

 

[tanahteck]

hi thanks for the quick repsonse, however it doesnt seem to work after i follow what you had describe.

 

[Tazguy37]

You could always try (in another column, B, for example):

=TRIM(A1)

and copy down the column.
Then copy that column, select Column A again, and use Edit, Paste Special, Values to paste it back to Column A as text values.