Deleting Space at End of Cell.

tanahteck

New Member
Joined
Nov 22, 2005
Messages
2
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

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
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

New Member
Joined
Nov 22, 2005
Messages
2
hi thanks for the quick repsonse, however it doesnt seem to work after i follow what you had describe.
 

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
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.
 

Forum statistics

Threads
1,078,012
Messages
5,337,724
Members
399,165
Latest member
ghoshwin

Some videos you may like

This Week's Hot Topics

Top