Deleting blank spaces in cells

[Mr Gow]

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!

* Great Thanks for all your help

[Norman Jones]

Hi Mr Gow,

Look at the Trim function in Excel help.

Trim will remove the leading and trailing spaces.



---
Regards,
Norman



"Mr Gow" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[JMB]

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
>
>

[Norman Jones]

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

[Dave Peterson]

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