I need to remove characters ...

I have a column of data that I wish to remove the first 2 characters from.
Is there a way to quickly do this? Below is the sample data.

Thank you,

Rick

c1122115
c1122116
c1122117
c1122118
c1122119
c1122120
c1122121
D1250592
D1250593
D1250594
D1250595
D1250596
D1250597
D1250598

You could insert a column and use this formula in that cloumn and drag it
down then copy and paste values.

=VALUE(MID(A1,2,8))


"Rick" wrote:

> I have a column of data that I wish to remove the first 2 characters from.
> Is there a way to quickly do this? Below is the sample data.
>
> Thank you,
>
> Rick
>
> c1122115
> c1122116
> c1122117
> c1122118
> c1122119
> c1122120
> c1122121
> D1250592
> D1250593
> D1250594
> D1250595
> D1250596
> D1250597
> D1250598
>

That did the trick, Thank You David!

"David Hepner" wrote:

> You could insert a column and use this formula in that cloumn and drag it
> down then copy and paste values.
>
> =VALUE(MID(A1,2,8))
>
>
> "Rick" wrote:
>
> > I have a column of data that I wish to remove the first 2 characters from.
> > Is there a way to quickly do this? Below is the sample data.
> >
> > Thank you,
> >
> > Rick
> >
> > c1122115
> > c1122116
> > c1122117
> > c1122118
> > c1122119
> > c1122120
> > c1122121
> > D1250592
> > D1250593
> > D1250594
> > D1250595
> > D1250596
> > D1250597
> > D1250598
> >