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

>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

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

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

"clock" <(E-Mail Removed)> wrote in message
news:8FEF3516-5802-44EE-B87F-(E-Mail Removed)...
> 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

=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