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!

 

[Norman Jones]

Hi Mr Gow,

Look at the Trim function in Excel help.

Trim will remove the leading and trailing spaces.

 

[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

 

[Guest]

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.

 

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