If you want to get rid of all the spaces--including any between words:

Select the range to fix
edit|replace
what: (spacebar)
with: (leave blank)
replace all

Mr Gow wrote:
would become
MrGowwrote:



Mr Gow wrote:

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

--

Dave Peterson