MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Removing Text Spaces within a Cell

Posted by Alex Waldman on August 30, 2001 6:09 PM

WE have a a column of product codes as text. In each cell the product coed has spaces ie "R COLL 1A -WIS". I need to eliminate all these spaces between the text. Please Help.

Posted by Coltsfan86 on August 30, 2001 6:20 PM

The CLEAN function will remove all non-printable characters from the text string.

Posted by Juan Pablo Gonzalez on August 30, 2001 6:25 PM

Well, if i may say, there are one easy and fast way yo do that, and many other not that easy but just as effective. If you wanna eliminate ALL the spaces, then just select the entire column, select edit-replace, type in first box a single space and then click "Replace All". That should eliminate all the spaces.