MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Removing spaces from copied text

Posted by jsp on November 10, 2000 7:15 AM


Sometimes when I copy text to Excel, it pastes de Text
leaving some spaces at the marginsthat werent there :

For Ex.

' Word1 Word2.....
' Word3 Word4.....

Is there any way to create a Macro that will look for
the empty spaces and remove them? Right now I have to edit
each cell.

Thanks in advance!

Posted by Loren on November 10, 2000 7:47 AM

Try Trim function or Edit-Fill-Justify

Posted by jsp on November 10, 2000 9:56 AM


Thanks for your reply!

Works great!