View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
A.S. A.S. is offline
external usenet poster
 
Posts: 79
Default macro or formula to get rid of a number

is there a formula that i can drag or macro that allows me to get rid of
specific digits?

Example data:

20
1191
88018
1514
119411
119147
11551123
119146

I need to get rid of all "11" that are in the beginning, however, not if
they are at the end or in the middle.

So the data would look after editing like:

20
91
88018
1514
9411
9147
551123
9146