=RIGHT(A1,LEN(A1)-1) entered in B1

Copy down to B4

Select B1:B4 and copypaste specialvalues onto column A

Delete column B


Gord Dibben MS Excel MVP


On Mon, 13 Jun 2011 10:51:59 -0700 (PDT), Mike wrote:

Hi everyone,

Say I have this:

T1
T4
T20
T100
.
.

I want to create a col that has it like this:
1
4
20
100
.
.

any simple way to do this?

Mike