D
Dazed and Confused
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.
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.