View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rciolkosz rciolkosz is offline
external usenet poster
 
Posts: 13
Default Alpha with numeric and numeric only numbers in a column

I have a column with 2 alpha letters leading numbers and also numbers only in
the same column. I want to put all records in a new column without any
alpha. How would I do that?

Example:

ar3456789
bt56789
234567
78901234
etc.