View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hogsy hogsy is offline
external usenet poster
 
Posts: 1
Default format cell to place colon btw every 2 alphanumeric characters

we have part numbers that are 12 alphanumeric characters. They need to be
entered into a cell and the cell needs to automatically place a colon between
every two. I have been able to customize the cell to do so between every two
numbers or every two letters, but it will not do it when there is a mix of
letters and numbers