Hi all
I have spreadsheet (converted from report) which contains cells that
contain data and blank spaces. I want to keep the data and delete the
blank spaces. All cells are not formatted the same eg some are 4 blank
spaces and then text, some are text and 14 blank spaces. Please help!


--
Mr Gow
------------------------------------------------------------------------
Mr Gow's Profile: http://www.excelforum.com/member.php...o&userid=34511
View this thread: http://www.excelforum.com/showthread...hreadid=542758