Help retaining formatting while using text to columns or other

I am working on a spreadsheet that has a column full of cells that have 17 three letter ids in them. Some ids are bold while others are not. That is my company's way of designating that they are active or not.
I am trying to split them into individual columns while retaining the bold and normal formatting of the ids. The Text to Columns function loses the formatting, and would make this project a nightmare if I have to manually reapply the formatting.
Any ideas about how to do this would be much appreciated.
Thanks in advance,
Ian

Hi
Try to use this function VBA in a module and use it in Excel

Please Login or Register  to view this content.

You can use them to mark registers as actives or you can use in conditional formatting.

This is a copy of the data I have. The first column needs to be split into separate columns without losing the bold/regular formatting.

Hi
Try this code VBA in a module
You may need change "Bold" to another FontStyle (in the portuguese version is "Negrito")

Please Login or Register  to view this content.

Select the range A2:A10 (adjust as need, only one column) and run the code SplitBold.
Note that columns B2:R10 will be overwrited.
See the file

Thank you José,

That worked to split the cell, however it comepletely overwrites everything to the right it, even if there are more than enough spaces for it to expand.

/Thank you José,

That worked to split the cell, however it comepletely overwrites everything to the right it, even if there are more than enough spaces for it to expand.
I need to be able to split the first column without damaging the rest of the data. I tried to build a buffer, but that doesn't work.

Hi
Sorry for my mistake. It is suppost to overwrites only Columns B:R. "What the parentheses can do!"
Try this

Please Login or Register  to view this content.

Thank you for all of your help. I have 58 rows on over 100 sheets that will be much easier to fix now that I have this macro.

Before this, I had no idea what macros were and that VBA even existed. Fortunately I pick up on things pretty quick. How would you recommend going about learning how to use VBA and build my own macros?