Formatting cells with numbers and text

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.
 
E

Eduardo

Hi,
try

=LEFT(B7,2)&"-"&MID(B7,3,4)&"-"&RIGHT(B7,3)

change the cell # to fit your needs
 
Top