View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] namemattersnot@msn.com is offline
external usenet poster
 
Posts: 1
Default How to add alphanumeric data? (e.g., 1C+2D)

I have a set of alphanumeric data. How do I add just numbers, leaving
letters behind?

For instance, 1X+2X+3X should = 6. Any suggestions?

Thanks!