Deleting a consistant portion of all cells in a given column
 

I need to remove only the first 10 characters of 40 character cells in a
given column.
What is the formula to produce this result? All cells are currently 40
characters in length.
--
clock

Deleting a consistant portion of all cells in a given column
 

I need to remove only the first 10 characters of 40 character cells in a
given column.
What is the formula to produce this result? All cells are currently 40
characters in length.

=MID(A2,11,999)

Rick

Deleting a consistant portion of all cells in a given column
 

I need to remove only the first 10 characters of 40 character cells in a
given column.
What is the formula to produce this result? All cells are currently 40
characters in length.

=MID(A2,11,999)

I realize you said all of your text is 40 characters in length which means
you could have used this instead...

=MID(A2,11,30)

but if your text ever got longer, the extra characters from character
position 41 onward would be truncated away. Using a number larger than you
need will protect against your text ever becoming longer. Another
possibility, which automatically protects against longer text being
introduced later on is this formula...

=REPLACE(A4,1,10,"")

Rick

Deleting a consistant portion of all cells in a given column
 

=mid(a2,11,len(a2))

"clock" wrote in message
...
I need to remove only the first 10 characters of 40 character cells in a
given column.
What is the formula to produce this result? All cells are currently 40
characters in length.
--
clock

Deleting a consistant portion of all cells in a given column
 

=right(a1,30)

"clock" wrote:

I need to remove only the first 10 characters of 40 character cells in a
given column.
What is the formula to produce this result? All cells are currently 40
characters in length.
--
clock