MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Space problems


Posted by Michelle on November 14, 2001 6:58 PM

I have a spreadsheet with 1000 rows of data. Every cell has a space before the text making it impossible to sort with other data lists I need to merge. Is there a quick fix?

Thanks for ANY help!


Posted by Dan on November 14, 2001 7:57 PM

Is the data in a single column? If so, try this:

Highlight the column, click on the Data menu and choose Text To Columns. Choose "Fixed width", click Next. Then use your mouse to put a break line after the first character space. Then click finish. This will break your column in to two separate columns and leave the space out.

HTH