Deleting blank spaces in cells
 

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

Deleting blank spaces in cells
 

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

Deleting blank spaces in cells
 

Hi Mr Gow,

Depending on the nature of the spaces, you may also wish to visit David
McRitchie's TrimAll page at:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall


---
Regards,
Norman

Deleting blank spaces in cells
 

You can set up a helper column and use the TRIM function to remove extra
spaces.

=TRIM(B1)

Then copy this formula as far as necessary, copy, click Edit/PasteSpecial -
values. Then delete the original data. Play with it a little bit, just be
sure to back up your data.


"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

Deleting blank spaces in cells
 

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