Removing Blanks from Multiple Cells _Using Excel 2007

[Jim]

Using EXCEL 2007 ........I have a column of data that has 5 blank spaces in
the first 5 positions. I would like to remove these blank spaces. When I
clicked on the Fx icon it placed an = sign next to the Fx icon and launches
me into a formula wizard screen. I'm trying to apply the following formula
to get rid of the first 5 positions using the following formula
=RIGHT(A1,LEN(A1)-5) or alternativelyI thought I would try the following
formula to apply to the total column: =RIGHT(A1:A383,LEN(A1:A383)-5))

Several issues.
1. Are these formulas correct.
2. How can I just enter the formula without using the wizard?
3. How do I get this formula to apply to the whole column?

Thanks for any help. /jim

 

[T. Valko]

1. Are these formulas correct.

The first one is:
=RIGHT(A1,LEN(A1)-5)

2. How can I just enter the formula without using the wizard?

Just select the cell where you want the formula and type it in starting it
with the = sign.

3. How do I get this formula to apply to the whole column?

Drag copy the formula down the column. Assume you enter this formula in cell
B1:

=RIGHT(A1,LEN(A1)-5)

See this screencap:

http://img301.imageshack.us/img301/4130/fillhandlesj0.jpg

See that little black square on the bottom right side of the selected cell.
That's called the fill handle.
Hover your mouse over the fill handle until it changes from a "fat plus
sign" to a "skinny plus sign". When it does this click and hold the left
mouse button down then just drag down the column. This will copy the formula
to every cell that you drag it to and the formula references will
automatically adjust as you drag.

Another way to use this fill handle to your advantage is if the data in
column A is in a solid contiguous range you can enter the formula in cell B1
then just double click the fill handle. This will automatically copy the
formula down column B and it will automatically stop where the data ends in
column A.

Biff

 

[excelent]

ur first formula is ok, the second wont work

why not just select list then Edit>Replace
in field "Look at" put in a space
in field "Replace with" nothing
click on Replace all



"Jim" skrev:

 

[Teethless mama]

=TRIM(A1)
copy down as far as required