ASAP Utilities is a powerful Excel add-in that fills the gaps in Excel and automates frequently used tasks. Since 1999 it has grown to become probably one of the world's most popular add-ins for MS Excel.
* Sheets » Insert multiple sheets (uses the cell values as sheet names)...
In version 4.5.5 we updated this utility: "When you used a template sheet that contained cells with more than 255 characters, the excess characters were stripped off on the newly created sheet. That also happens when you manually copy a sheet with more then 255 characters and Excel will then warn you about this. We have now updated the utility so that it also is an exact copy when there are cells with values of more then 255 characters."
However, if you used in-cell formatting (for example where you used multiple fonts in the same cell or a part of the value was bold), this updates caused that that specific formatting was reset to the default formatting of that particular cell.
This is now fixed.
Tools and Utilities
Product page: here