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