View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Formatting AlphaNumeric string in a cell

Yes, there is absolutely a way to do it, but the answer depends on your source data. Are those long alpha numeric strings *always* the same length, and do the periods *always* appear in the same place, or does it vary?