software

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: www.excelforum.com/member.php...oamp;userid=34511
View this thread: www.excelforum.com/showthread...hreadid=542758Hi Mr Gow,

Look at the Trim function in Excel help.

Trim will remove the leading and trailing spaces.
---
Regards,
Norman
quot;Mr Gowquot; gt; wrote in
message ...
gt;
gt; Hi all
gt; I have spreadsheet (converted from report) which contains cells that
gt; contain data and blank spaces. I want to keep the data and delete the
gt; blank spaces. All cells are not formatted the same eg some are 4 blank
gt; spaces and then text, some are text and 14 blank spaces. Please help!
gt;
gt;
gt; --
gt; Mr Gow
gt; ------------------------------------------------------------------------
gt; Mr Gow's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34511
gt; View this thread: www.excelforum.com/showthread...hreadid=542758
gt;
Hi Mr Gow,

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

www.mvps.org/dmcritchie/excel/join.htm#trimall---
Regards,
Norman
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.quot;Mr Gowquot; wrote:

gt;
gt; Hi all
gt; I have spreadsheet (converted from report) which contains cells that
gt; contain data and blank spaces. I want to keep the data and delete the
gt; blank spaces. All cells are not formatted the same eg some are 4 blank
gt; spaces and then text, some are text and 14 blank spaces. Please help!
gt;
gt;
gt; --
gt; Mr Gow
gt; ------------------------------------------------------------------------
gt; Mr Gow's Profile: www.excelforum.com/member.php...oamp;userid=34511
gt; View this thread: www.excelforum.com/showthread...hreadid=542758
gt;
gt;

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:
gt;
gt; Hi all
gt; I have spreadsheet (converted from report) which contains cells that
gt; contain data and blank spaces. I want to keep the data and delete the
gt; blank spaces. All cells are not formatted the same eg some are 4 blank
gt; spaces and then text, some are text and 14 blank spaces. Please help!
gt;
gt; --
gt; Mr Gow
gt; ------------------------------------------------------------------------
gt; Mr Gow's Profile: www.excelforum.com/member.php...oamp;userid=34511
gt; View this thread: www.excelforum.com/showthread...hreadid=542758

--

Dave Peterson