View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 102
Default Doing this in Excel?

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