Prev: Reminder - Microsoft Responds to the Evolution of Community
Next: Excel 2007 (Not Responding)
From: tim m on 20 May 2010 12:40
You can use the 'Trim' function for this. It removes blanks spaces from a
cell except for blank spaces between words.

- Insert a column next to the column that needs to be changed.
- Enter the formula =TRIM(put the cell you want trimmed here)
- Then copy the formula down the as far as your data goes.

It should trim the leading blank spaces. You then can 'copy' the column
with the trim formulas and 'paste special'....values over top of original
column. Then just deleted the column with the TRIM formulas.

As with all changes to your data in a spreadsheet, make a back up copy of
your sheet before making any mass changes like this.

"fazz" wrote:

> Hello Tim - what i really need to be able to do is remove blank spaces at the
> beginning of a cell
>
> "tim m" wrote:
>
> >
> >
> > "fazz" wrote:
> >
> > > is it possible to highlight multiple cells and delete characters from the
> > > beginning of them?
> >
> > Can you give an example of some of the data? Is the data all the same
> > length? Do you always just want to removed 1 character from the front or
> > does that vary? There are formulas you can use to accomplish this but what
> > formula you use depends on what your data is like.
From: Eduardo on 20 May 2010 12:50
Hi,
Let' say the column with blank is column A in another column enter

=trim(A1)

copy formula down, then do copy, go to column A, paste as values

"fazz" wrote:

> Hello Tim - what i really need to be able to do is remove blank spaces at the
> beginning of a cell
>
> "tim m" wrote:
>
> >
> >
> > "fazz" wrote:
> >
> > > is it possible to highlight multiple cells and delete characters from the
> > > beginning of them?
> >
> > Can you give an example of some of the data? Is the data all the same
> > length? Do you always just want to removed 1 character from the front or
> > does that vary? There are formulas you can use to accomplish this but what
> > formula you use depends on what your data is like.
From: fazz on 21 May 2010 09:34
thanks...it all works now..

"Eduardo" wrote:

> Hi,
> Let' say the column with blank is column A in another column enter
>
> =trim(A1)
>
> copy formula down, then do copy, go to column A, paste as values
>
> "fazz" wrote:
>
> > Hello Tim - what i really need to be able to do is remove blank spaces at the
> > beginning of a cell
> >
> > "tim m" wrote:
> >
> > >
> > >
> > > "fazz" wrote:
> > >
> > > > is it possible to highlight multiple cells and delete characters from the
> > > > beginning of them?
> > >
> > > Can you give an example of some of the data? Is the data all the same
> > > length? Do you always just want to removed 1 character from the front or
> > > does that vary? There are formulas you can use to accomplish this but what
> > > formula you use depends on what your data is like.
First  |  Prev  | 
Pages: 1 2
Prev: Reminder - Microsoft Responds to the Evolution of Community
Next: Excel 2007 (Not Responding)