View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Dazed and Confused[_2_] Dazed and Confused[_2_] is offline
external usenet poster
 
Posts: 14
Default Formatting cells with numbers and text

I have a column of numbers with text; i.e., 23L252350, 06K100997, 50J304888,
etc. These numbers and text need to have a hyphen inserted after the first
two numbers/characters and the next four numbers/characters, i.e.,
23-L252-350, 06-K100-997, 50-J304-888. I tried using
Format-Cells-Number-Custom, but cannot seem to get it to work since the 3rd
character is usually (but not always) text.

Any assistance would be greatly appreciated. Thank you.