View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gdd6936
 
Posts: n/a
Default How do I make letters not show up in a alpha-numeric string?

I have data that appears like this: "R1-C2-D1-12". I would like the same data
appear in another column like this: "1-2-1-12". How can I make this happen
without spending hours typing it in, I have several thousand lines?