Formatting cells with numbers and text
Sorry, add the formula in a column beside where you have the information
"Eduardo" wrote:
Hi,
try
=LEFT(B7,2)&"-"&MID(B7,3,4)&"-"&RIGHT(B7,3)
change the cell # to fit your needs
"Dazed and Confused" wrote:
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.
|