Hi Mr Gow,

Look at the Trim function in Excel help.

Trim will remove the leading and trailing spaces.



---
Regards,
Norman



"Mr Gow" wrote in
message ...

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